Crosstab with out alphabetical order

Max4341

Hey Everyone, I'm new to the community but Ive been using Alteryx for a little over a year. Many of the reports I do use the cross tab tool. I was curious if there is a way to avoid the tool transfering all the input information alphabetically? Thanks!

tom_montpool

There isn't a way to avoid it, but you can put the fields back into their 'proper' order with the Field Info, Formula, Dynamic Rename and Select tools.

Use Field Info to get the original list of fields

Use Formula to create a padded rename of the original field list (e.g. 00001_Field1, 00002_More)

Use Dynamic Rename to rename the crosstab results to your padded names

Use Select (Sort by Field Name) to change the sort

Use Dynamic Rename to set the field names back to their original state

Play safe!