Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_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 |
2)
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.
Try using MapSubstring()