Need help to implement logic.

lalitkgehlot89 — Fri, 15 Nov 2024 23:21:39 GMT

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.

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

Country Code	Country Name
AF	Afghanistan
AL	Albania
AM	Armenia
AO	Angola
AQ	Antarctica
AR	Argentina
AT	Austria
AU	Australia
AW	Aruba
AZ	Azerbaijan
BA	Bosnia and Herzegovina
BB	Barbados
BD	Bangladesh
BE	Belgium
BH	Bahrain
BJ	Benin
BM	Bermuda
BO	Bolivia
BS	Bahamas
BT	Bhutan
BY	Belarus
BZ	Belize
DZ	Algeria
IN	India

Required output:-

variant_id	Country Code	Country Name
5116877-92622444918	AF,AL,IN,DZ	Afghanistan,Albania,India,Algeria
5116877-30291423626	AF,AL,IN	Afghanistan,Albania,India

please help me to implement the logic for the same.

Re: Need help to implement logic.

tresB — Thu, 07 Jan 2021 05:42:12 GMT

Try using MapSubstring()

topic Re: Need help to implement logic. in QlikView

Need help to implement logic.

Re: Need help to implement logic.