Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Creator II
Creator II

Need help to implement logic.

Hi,

I have two data sets.

First one has the country code and another on has the country name. Need to mapp the country name against the country code. sample data is given below.

1) 

variant_idCountry Code
5116877-17783988067IN,AR,AU,AT,AW,AZ,BS,AM,BH,BD,BB,BY,AQ,BE,BZ,BJ,BM,BT,AO,BO,BA
5116877-30291423626AF,AL,IN
5116877-52414305444AF,AL,IN
5116877-63540993637AF,AL,IN
5116877-80702101854AF,AL,IN
5116877-92622444918AF,AL,IN,DZ

 

2) 

Country CodeCountry Name
AFAfghanistan
ALAlbania
AMArmenia
AOAngola
AQAntarctica
ARArgentina
ATAustria
AUAustralia
AWAruba
AZAzerbaijan
BABosnia and Herzegovina
BBBarbados
BDBangladesh
BEBelgium
BHBahrain
BJBenin
BMBermuda
BOBolivia
BSBahamas
BTBhutan
BYBelarus
BZBelize
DZAlgeria
INIndia

 

Required output:- 

variant_idCountry CodeCountry Name
5116877-92622444918AF,AL,IN,DZAfghanistan,Albania,India,Algeria
5116877-30291423626AF,AL,INAfghanistan,Albania,India

 

please help me to implement the logic for the same.

Labels (2)
1 Reply
tresesco
MVP
MVP

Try using MapSubstring()