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 · Accepted 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!

[MichelSza]

Hi Max,

You could add a recordID for all the records of the input.

You just have to add RecordId as s grouping field in the cross-tab tool

Have a look at the attached test.

hope it helps

Michel

[Max4341]

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.