Dynamically change column headers to have Fiscal Year prefix

[mercurial_maverick]

Hello,

I've a datasource that has 20+ columns out of which I need to dynamically change/update the names of 2 columns with a prefix. These 2 columns are "Current_Budget" and "Total_Actual". I need them to change to "FY22_Current_Budget" & "FY22_Total_actual". "FY22" is current fiscal year. so when we move to next Feb this needs to update to FY23.

Please attached test file that has the list of columns and the concerned columns are highlighted in yellow.

[afv2688 · Accepted solution]

Hello @mercurial_maverick ,

How about this solution

Regards

[mercurial_maverick]

@afv2688 Perfect, much appreciated!