Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Help to map the country name to a field.

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
1 Solution

Accepted Solutions
1 Reply
sunny_talwar