Quick Way to Remember CrossTab vs Transpose

dawnh80

What's the difference between the Cross Tab 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 = Cross Tab

 

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.

 

fmvizcaino

Thanks for your contribution!

I'm using Alteryx for 5 years now and even now, I need to check the tool images to be sure which one I need to use