Dynamically Reorder Columns

[adam_rafael_18]

Hello, I am looking to join 2 datasets and run a process monthly. Each dataset will have one column per month for the current year (so as an example, dataset one will have:

1) Calculated_January

2) Calculated_February

3) Calculated_March

through end of March. Through the end of April, it would have these three columns, plus a fourth column (Calculated_April) and so on for the remainder of the year. The other data set will be similar:

1) Actual_January

2) Actual_February

3) Actual_March

and additional columns as the year progresses. I want to reorder them so that the January columns are next to each other, then the February columns are next to each other, etc. Is there a way to do dynamically as the year progresses to include the additional months?

Thanks!

[AngelosPachis]

Hi @adam_rafael_18 ,

This is what I came up with. I tested it and as I added months on both the calculated and actuals dataset, they were still sorted correctly.

Give it a try, hope that helps.

Angelos

[adam_rafael_18]

Thanks a lot Angelos - sorry for follow up, but I'm having trouble opening up the file (says it is with a newer version of alteryx) - do you know how I can open it with 2019.4?

Thanks,

Adam

[PhilipMannering]

Hi @adam_rafael_18 

Can you open this? (This is @AngelosPachis  workflow downgraded)

[PhilipMannering]

Although @adam_rafael_18 and @AngelosPachis, I'm not sure that the sorting in the Select Tool is dynamic. Think once you get new data is just adds that extra column to the end.

This might work as an alternative,