Hi there,
I would like to build a workflow where the column names include the the following months:
However, I want the column names to automatically change over time.
So, I want that the column names to automatically change to Dec 22, Jan 23-Dec 23 and Jan 24-Dec next year.
How do I integrate this in my workflow?
Solved! Go to Solution.
Hi @sophievanluin ,
using a Dynamic Rename tool could solve your problem:
The assumption is, that you name your columns "LY", "Jan CY" - "Dec CY" and "Jan NY" - "Dec NY", thereby using a kind of placeholder for the year. The Dynamic Rename tool can replace these placeholders by the year.
Let me know if it works for you.
Best,
Roland
That's exactly what I mean, thank you very much!
I do have another question, how do I make sure that the data in the rows will still be applicable to the same columns if the columns will be named differently every year?
E.g., if I now use a formula tool for Dec 21, it will not be applicable to Dec 22 next year.
-
Hi @sophievanluin ,
a solution could be to rename the columns as a last step of the workflow, e.g. "Jan 23" as a field name/column header would appear only in your output, for a steps before the name would be "Jan NY" and in all formulas or summarize tools, [Jan FY] would be used.
Do you think this would be work in your workflow?
Best,
Roland