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?

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?

Date Time

Dynamic Processing

Preparation

Accepted answers

RolandSchubert

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

Header.yxmd

RolandSchubert

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

All comments

atcodedog05

Hi @sophievanluin

Here is how you can do it.

Input:

Workflow:

Hope this helps : )

dynamic name.yxmd

RolandSchubert

Hi @sophievanluin ,

using a Dynamic Rename tool could solve your problem:

Let me know if it works for you.

Best,

Roland

Header.yxmd

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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335