Wrap-up

Data Transformation in Alteryx

Josh Honken

Senior Associate, Knowesis

Formula tool

Screenshot 2024-03-18 205811.png

Formula_71x71.png

  • IF
  • ELSEIF
  • IIF
  • AND
  • OR
  • NOT
  • CONTAINS
Data Transformation in Alteryx

Transpose tool

Screenshot 2024-03-18 210539.png

TransposePivot_71x71.png

  • Key Columns
  • Data Columns
  • Missing Columns
Data Transformation in Alteryx

Cross tab tool

Screenshot 2024-03-18 211724.png

CrossTabPivot_71x71.png

  • Group data by these values
  • Change Column Headers
  • Values for New Columns
  • Method for Aggregating Values
Data Transformation in Alteryx

Next steps

data analyst walking down a path with etl, gears, databases lining it out in nature

Data Transformation in Alteryx

Congratulations!

Data Transformation in Alteryx

Preparing Video For Download...