Column rename

Hi,

If in a given column lets say I want to rename a particular group of events how can I do that by creating a new column.

For eg :- In a given column I have FETA-FETA as one grouping and need to rename it as Liquidity in a new column, how can I do that.

Thanks for your help.

Accepted answers

Nest all conditions into the same formula tool. Instead of using the IF x THEN y ELSE z ENDIF syntax, you would use the ELSEIF syntax.

The reason why FTEA-FETA is blank is because the column is using the last set of rules.

if [Transfer Agency] ='FETA - FETA' then 'Liquidity'

elseif contains([Business], "Institutional") then "Institutional"

else "blank" endif

If I understand your question correctly, you would use a conditional statement in a formula tool.

In the output field, create a new column by selecting "Add Column" and then typing in the new column name.

In the expression window, you would use a conditional statement like the below:

if [FIELD] = 'FETA-FETA'

then 'Liquidity'

else [FIELD]

endif

Thank you for replying.

I have used the below conditional statement

if [Transfer Agency] ="FETA-FETA" then "Liquidity" else "blank" endif

however I am getting all blank in the new column