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!
Solved! Go to Solution.
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!
I should of mentioned I am grouping a list of questions across several hundred stores so the recordID tool won't put the question order back in place. I usually map the questions to the order I need but I was just wondering if there was a way to modify the cross tab so I wouldnt have to create a seperate map document. Thanks again for the quick suggestions.