Transpose overview

Data Transformation in Alteryx

Joshua Honken

Senior Associate, Knowesis Inc.

Pivoting columns into rows

wide table before transpose operation

Data Transformation in Alteryx

Pivoting columns into rows

transpose operation on a wide table

Data Transformation in Alteryx

Pivoting columns into rows

transpose operation on a wide table

Data Transformation in Alteryx

Pivoting columns into rows

Rows and columns results with transpose

Data Transformation in Alteryx

Renaming with the select tool

rename your new columns with the select tool

Data Transformation in Alteryx

Dropping columns and mixing data types

expanding the original state sales table to seven columns

Data Transformation in Alteryx

Dropping columns and mixing data types

expanding the original state sales table to seven columns

Data Transformation in Alteryx

Dropping columns and mixing data types

original table and transposed table with explanation

Data Transformation in Alteryx

Dropping columns and mixing data types

finaltransposetable.png

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

Let's practice!

Data Transformation in Alteryx

Preparing Video For Download...