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.
Hi @hemant86
Look into the dynamic rename tool. You could use a formula to replace 2021 with 2022
https://help.alteryx.com/20214/designer/dynamic-rename-tool
Thanks @Luke_C . I was trying the same but I guess I was goin wrong with the expressions. I managed to fix that now. Thanks Again
Glad you're set @hemant86 . Lots of great solutions here don't forget to mark them as such!
Thanks @atcodedog05 . Not very good at reg Ex. I missed to mention that I'm keeping the Headers fixed as "MinWage_04/01/" and only adding Year at the end. But since the formula changes for last 3 columns I'm currently using 2 Dynamic tool to achieve that. How can I achieve this only using 1 dynamic tool.
Hi @hemant86
Possibly I am not clear on your ask. In my workflow it dynamic adds +1 year to all columns.
Can you provide some sample input and expected output It will help us get a better understanding of the usecase.
We will be happy to help : )