replace part of string

[SouravKayal]

Hi Guys,

So i have a few columns like 2021 D Jan P $ , 2021 D Feb P $. These are all double fields having number values. I want to be able to replace the headers from 2021 D Jan P$ to  S_Jan X $ , So basically relpace specific characs.

[ImadZidan]

Hello @SouravKayal ,

more thank way to do this. Please have a look at the attached workflow.

If it is one column you are after then use the top flow. If many then use the bottom one where it uses a sort of mapping table to drive the replacement.

I hope it helps.

[Qiu]

@SouravKayal 
How about a Dynamic Rename Tool?

[SeanAdams]

as @Qiu says, you can rename columns with a dynamic rename tool.

Additionally - you can transpose the data into name-value pairs; change the column names using a regular old formula tool; and then use the cross-tab tool to return this from rows to columns.    This method is VERY helpful if you have a variable number of columns (like rolling months for transaction data)