Dynamic column names with months

[sophievanluin]

Hi there,

I would like to build a workflow where the column names include the the following months:

• December from last year (e.g., Dec 21)
• Full current year (e.g., Jan 22 till Dec 22)
• Full next year (e.g., Jan 23 till Dec 23)

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?

[atcodedog05]

Hi @sophievanluin 

Here is how you can do it.

Input:

Workflow:

Hope this helps : )

[RolandSchubert · Accepted 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

[sophievanluin]

Hi @RolandSchubert 

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.

[atcodedog05]

-

[RolandSchubert · Accepted solution]

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