I have a file that has column headings which contain the names of the most recent 3 months. So obviously next month's columns would show different months than this month's. I have 3 sets of these for 3 different metrics where I want to see their values across 3 months. The problem is when a new month comes, it puts the new months at the end.
So instead of the desired order like CPU_2023-05,CPU_2023-06,CPU_2023-07, RPU_2023-05,RPU_2023-06,RPU_2023-07 I get CPU_2023-05,CPU_2023-06, RPU_2023-05,RPU_2023-06,CPU_2023-07,RPU_2023-07
Just moving unknown columns in the select tool doesn't work because the unknown columns would still be at the end vs. in order with their respective metric. So I tried to create an input with the next few years' worth of these column names, add it to a union, have them in the order I want, remove the Union, and then they would still be in order but as missing columns. So when they appear they would be in the right order. I am finding though that somewhere at the table tool to report tool top format and output, it loses these missing columns and the order.
Is there a way to get the columns in the right order for future months? Thanks!
