Rename Multiple Columns in Different Locations

Question

I have a table with header names

x1x2Ax4x5BCx8

I want to rename A, B and C to Happy, Sad, and Lucky, just as an example. I have tried using formulas with dynamic rename but none of it is recognized/syntax is incorrect:

IF [_CurrentField_]=="A" THEN [_CurrentField_]=="Happy" ELSEIF [_CurrentField_]=="B" THEN [_CurrentField_]=="Sad" ... etc

I tired using a right input data file, but that overwrites the first three column headers only and doesn't let me specify the column names I want it to change.

Felipe_Ribeir0 · Accepted Answer

Hi @shaheer

The correct way to use this formula is like this:

IF [_CurrentField_]=="A" THEN "Happy" ELSEIF [_CurrentField_]=="B" THEN "Sad" ELSE "Other" ENDIF