Cross tab tool overview

Data Transformation in Alteryx

Josh Honken

Senior Associate, Knowesis

Unpivoting columns with the cross tab tool

Cross tab is the reverse of transpose

Data Transformation in Alteryx

Unpivoting columns with the cross tab tool

cross tab tool explanation

Data Transformation in Alteryx

Unpivoting columns with the cross tab tool

cross tab tool explanation group data by these values

Data Transformation in Alteryx

Unpivoting columns with the cross tab tool

cross tab tool explanation change column headers

Data Transformation in Alteryx

Unpivoting columns with the cross tab tool

cross tab tool explanation values for new columns

Data Transformation in Alteryx

Unpivoting columns with the cross tab tool

cross tab example with data

Data Transformation in Alteryx

Unpivoting columns with the cross tab tool

cross tab example with data

Data Transformation in Alteryx

Unpivoting columns with the cross tab tool

cross tab example with data

Data Transformation in Alteryx

Cross tab aggregation methods

Data Icons

Numeric Options String Options
First First
Last Last
Sum Concatenate
Average
Count (Without Nulls)
Count (With Nulls)
Percent Row
Percent Column
Total Column
Total Row
Data Transformation in Alteryx

Cross tab aggregation methods (numeric fields)

Table explaining cross tab numeric options

Data Transformation in Alteryx

Cross tab aggregation methods (numeric fields)

Table explaining cross tab numeric options

Data Transformation in Alteryx

Cross tab aggregation methods (string fields)

table with string aggregation options

Data Transformation in Alteryx

Let's practice!

Data Transformation in Alteryx

Preparing Video For Download...