Dynamic rename if column contains certain words

[Jenina]

Hi All,

Can someone provide the correct expression, I just wanted to rename fields that contains a certain word

Thank you!

[binuacs · Accepted solution]

@Jenina sample attached. In Alteryx the field name should be unique, it will not allow duplicate names, as per your requirement there might be chance to create duplicate field names

[apathetichell · Accepted solution]

I think @Jenina is asking for the dynamic replace to work like this:

if contains([_CurrentField_],"WFC YTD Entered Balance") then replace([_CurrrentField_],"WFC YTD Entered Balance","Gla Balance") else [_CurrentField_] endif.

that is the same as:

replace([_CurrrentField_],"WFC YTD Entered Balance","Gla Balance") - because if the verbiage is not included it cannot be replaced.