Coloum format

[mihir_mir_jb]

Hi All,

I have a huge dataset where I need to rename components from a couple of columns.

Column Region has various names under it and all of it are to renamed as America.

US

LATAM

GWM America

GF US Funds

GIL Americas

Similarly I have below which needs to be renamed as EMEA

Europe

GWM PB Europe

Europe Other

How can I do this? 

[ramesh_neel · Accepted solution]

@mihir_mir_jb  - Have you tried the below using a formula tool?

IIF(Contains([Region], "Europe"),"EMEA","America")

[mihir_mir_jb]

Hi ram_neel, thank you vm for your reply.

Can I use the same formula if I have three regions to be renamed, the third one being Asia

[ramesh_neel]

@mihir_mir_jb  - This will not work in that case , we need to re write it based on the values that are under 'Asia' . Do you have a sample data set to share? 

[mihir_mir_jb]

Below regions to be renamed as America(non-US)

US

Latam

GWM-America

GF-US-Funds

GIL-Americas

GI-Latam

Below regions to be renamed as EMEA

Europe

GWM-PB-Europe

GWM-PB-ME

GI-Europe

Europe-Other

Global

Below region to be renamed as Asia

Asia

GWM-PB-Asia

GIL-Asia

GIL-Asia-Instl-Asia

GI-IN-International

[ramesh_neel · Accepted solution]

In this case , I have a different approach which makes it a lot more flexible  (Please refer to the attached workflow ). I have created a region mapping reference where each region is mapped to a group  and using the join tool I am joining region column from the reference table to the region column from the input data . If a new region gets added to your input data , all you need to do is add that region and the group it maps to in the reference table !