CrossTab vs Transpose

What's the difference between the CrossTab Tool and the Transpose Tool? Both tools are found in the Transform menu of Alteryx and are on the Alteryx Core Exam. One easy way to remember the difference between these two tools is below;

C for Columns = CrossTab

Look at the example below. We moved the Entity value to columns instead of having the data in a row value.

T for Tall = Transpose

Think of making your data 'Tall' or to add extra rows. The Transpose Tool takes the data from columns and transforms them into rows. It makes the data 'Tall.'

In the Example below we had a wide data set with multiple columns. We used the Transpose Tool to move the data from columns to rows. We eliminated extra rows. Please note that applications like Tableau prefer data in a tall format.

29 views0 comments