Adaptable column headers for changing dates.

[JaimeB]

Hi there again!

I need your help (again) with an issue that I'm facing. Every week I need to generate a new report of the utilization of internal resources, hence every week I need to download new raw data for this purpose. The data headers, which shows the monthly "utilized time" and the "utilization denominator" for the upcoming two months, changes every week that I generate the report, as it takes the next month values but always from the first day of the current week. Therefore, my headers always differ from week to week. Find here an example for this week:

How can I play around with the headers so I don't get an error, week after week, because the Alteryx Flow isn't finding the columns as they have changed of name? Is there any way to dynamically select the columns by their order as it never change?

Thanks in advance

[Christina_H]

If the column order is always the same, it's probably easiest to set up a new text input with the column headers you want to use, then union the new data to that by position.