Hi all,
I am currently working on a financial gross cost and headcount report. With the help of Alteryx the incoming Excel table shall be reordered (f. e. most important regions at the top), less important regions summarized in a "left over" position and the whole report eventually formatted.
The report comes in with the following structure:
Obviously, there is more to the table, that's just the first row. The first row should be more or less my column headers in my output. The problem is that both the first row and the current column headers change from time to time. "FC6" for example could be "FC9" in a few months. So can the current column headers that you see in that picture change once we slide into 2021 (FY2020_4 becomes FY2021_4). So there is no consistency in my column header naming which is my biggest problem as all the formula and select tools that follow won't recognize the columns anymore as soon as only one column comes in with a different name.
My workflow ends with the Table tool and Render Tool. So even if I created a manual consistency within my column headers which I did (f. e. naming the columns "previous FC" and "current FC") and wanted to add an hint of the actual description at the end of the workflow (f.e. "previous FC (FC3)" and "current FC (FC6)"), there will always be the Table tool that won't be able to process the change.
Maybe you guys know a solution for this, it actually has caused me quite an headache.
Thanks a lot in advance!
Best,
Tim
