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.

Common Use Cases

Accepted answers

atcodedog05

Hi @hemant86

Another way using Regex

Hope this helps : )

dynamic rename columns.yxmd

atcodedog05

Hi @hemant86

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

Hope this helps : )

rename headers (1).yxmd

All comments

Luke_C

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

binu_acs

@hemant86 as @Luke_C suggested

DynamicRename1.yxmd

atcodedog05

Hi @hemant86

Another way using Regex

Hope this helps : )

dynamic rename columns.yxmd

hemant86

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

Luke_C

Glad you're set @hemant86 . Lots of great solutions here don't forget to mark them as such!

atcodedog05

Hi @hemant86

If you are looking for dynamic solution where for coming years you don't need to change the formula you can give a look at @binu_acs and my approaches.