Dynamic Rename of Headers

[hemant86]

Hi Team,

I want to rename my headers dynamically. For current financial year the headers are as below

MinWage_4/1/2021

MinWage_5/1/2021

MinWage_6/1/2021

MinWage_7/1/2021

MinWage_8/1/2021

MinWage_9/1/2021

MinWage_10/1/2021

MinWage_11/1/2021

MinWage_12/1/2021

MinWage_1/1/2022

MinWage_1/2/2022

MinWage_1/3/2022

I want the headers should change to as below dynamically for next financial year. Basically only the year is changing and rest of the header remains same.

MinWage_4/1/2022

MinWage_5/1/2022

MinWage_6/1/2022

MinWage_7/1/2022

MinWage_8/1/2022

MinWage_9/1/2022

MinWage_10/1/2022

MinWage_11/1/2022

MinWage_12/1/2022

MinWage_1/1/2023

MinWage_1/2/2023

MinWage_1/3/2023

Appreciate any help. Thanks in advance.

[hemant86]

I have attached sample file with original Input headers and what I'm doing currently.

Sample workflow.

[binuacs]

@hemant86  I used your input file to generate the heading dynamically in different ways

[atcodedog05]

Hi @hemant86 

My take on this

Hope this helps : )

[hemant86]

Thanks @atcodedog05 . i see you are fixing the headers here to 04/01/2020,05/01/2020,...etc and so on. The Input file wont be having these. Please see the attached workflow what will be the exact headers after renaming. Can anything be done around that. Thanks Again in advance.

[atcodedog05]

Hi @hemant86 

Try this

Hope this helps : )

[hemant86]

Thanks @atcodedog05 . Not sure if I'm correct. But is this going to work for the Next Financial Cycle which will start from 04/01/2022?

From 04/01/2022 the headers should dynamically change to below:

Min Wage_4/1/2022

Min Wage_5/1/2022

Min Wage_6/1/2022

Min Wage_7/1/2022

Min Wage_8/1/2022

Min Wage_9/1/2022

Min Wage_10/1/2022

Min Wage_11/1/2022

Min Wage_12/1/2022

Min Wage_1/1/2023

Min Wage_2/1/2023

Min Wage_3/1/2023

[atcodedog05 · Accepted solution]

Hi @hemant86 

Try this I have setup a condition to check the month and change the year.

Hope this helps : )

[hemant86]

Thanks @atcodedog05 . This is amazing. This will do the job for me. 🙂

[atcodedog05]

Happy to help : ) @hemant86 

Cheers and have a nice day!