Help to map the country name to a field.

[durgabhavani]

Hi All,

I have one filed country code with country codes. Now I am looking to map the country names to country codes. please help me to map the country names

Data is like below. expected output follows in next screenshot.

Ctry_code

IN,AM,AU

PAK,ENG,HK,AUS

SL,NL,PL

US,CN,UK

IN

HK

AM

PL,PS

AR

AE,LB

IN,HK,UK

Expected Output

Country_Name

India,Armenia,Austrialia

Pakistan,England,Hongkong,Austrialia

Srilanka,Netherland,Poland

United States,China,United Kingdom

India

Hongkong

Armenia

Poland,Palestine

Argentina

United Arab Emirates,Lebanon

India,Hongkong,United Kingdom

[sunny_talwar · Accepted solution]

May be use MapSubstring ‒ QlikView