Changic header to static

[Tid14]

Hi, I am building a WF in which I have 3 headers namely

FY 2019

FY 2020

FY 2021

and I have to apply numeric formulas in these columns and then make it an app.

Here I want to use a logic where I can change these years Column to something static for applying the formula so when in next cycle the years will change to for eg:

FY 2020

FY 2021

FY 2022

we dont have to change anything in the WF and it picks from these headers only.

[AngelosPachis]

Hi @Tid14 ,

I would use a transpose tool in your app, so instead of getting the column headers as FY 2019 you get [Name] and [Value]. Then you can apply your logic referencing the values in the [Name] column.

Can't help further as I'm not sure about the logic, but if you provide an example then I'm sure we can help you build something.

Best,

Angelos

[terry10]

You can use the Dynamic Rename tool. In the tool configuration, set the rename mode to 'Formula'.

There are many formulas you could use. See attached workflow for one example using REGEX_replace to replace any instances of "FY " with nothing.  REGEX_Replace([_CurrentField_], 'FY\s', '')

This regex approach will not need to be changed when there are new columns for 2022, 2023, 2024...  If you aren't comfortable with regex, there are other ways to do this, but regex is awesome!

Does this answer your question?

[ArtApa]

Hi @Tid14 - Here is what you can do make your WF dynamic:

Dataset 1:

Dataset 2:

The WF adds +1 to all fields: