Transpose overview

Data Transformation in Alteryx

Joshua Honken

Senior Associate, Knowesis Inc.

Pivoting columns into rows

Pivoting columns into rows

Pivoting columns into rows

Pivoting columns into rows

Renaming with the select tool

Dropping columns and mixing data types

Dropping columns and mixing data types

Dropping columns and mixing data types

Dropping columns and mixing data types

• Pivoted columns
• Dropped columns
• Mixed data types in value column
• Selected multiple key columns

Let's practice!

Data Transformation in Alteryx