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.
Solved! Go to Solution.
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.
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 |
Hi @hemant86
Try this I have setup a condition to check the month and change the year.
Hope this helps : )
Thanks @atcodedog05 . This is amazing. This will do the job for me. 🙂
Happy to help : ) @hemant86
Cheers and have a nice day!