To group columns in order

Question

Hi Team,

I am working on report which consists of 5 quarter columns in sequence with other calculated columns.

Quarter column names are calculated dynamically meaning thereby when I am running the workflow using calendar app for the month of Dec 2022---one of my quarter column will be named as Q42022 and logic has been set to name other quarter column as Q32022 and we have remaining quarter columns from the input files.

So in this case I have Q42021,Q12022,Q22022,Q32022,Q42022. along with other calculated columns.

Now the issue is when I am running for new quarter, these quarters are getting reshuffled everytime and I am not getting them in the above sequence.

Is there a way to group the above quarters and keep them in sequence with every new run.

Thanks in advance

Polite123 · Answer

Hi @Felipe_Ribeir0 ,

Thanks for the solution.

But it didnt help me much as the data is getting reshuffled.

Do you have any other way?

Felipe_Ribeir0 · Answer

Hi @Polite123

Here is a good trick to keep columns in a specific order, i believe that you just need to adapt to your use case:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Column-Sort-Order/td-p/662864