Dynamically Reorder Columns

Question

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!

philipmannering · Answer

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,

sort-month-headers.yxmd

philipmannering · Answer

Hi @adam_rafael_18

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

sample_workflow.yxmd

adam_rafael_18 · Answer

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