rename country name in text object

[mbp198]

I have a qlikview file which have a text object that is showing countries the for text object that is fetching countries is

=]FIN-AP-Company Code Country Text]

now there are some countries in the source data that are not named correctly, now what should I do in qlikview file so that country name is renamed to proper name

Current Name	Rename to
Utd.Arab Emir.	United Arab Emirates
Bahráin	Bahrain
Rep.of Congo	Republic of Congo
Cote d'Ivoire	Ivory Coast
Camerún	Cameroon
Argelia	Algeria
Gabón	Gabon
Guinea Ecuatori	Equatorial Guinea
Jordania	Jordan
Níger	Niger
Omán	Oman
Sudáfrica	South Africa

[settu_periasamy]

Hi,

Try to create the Inline table with your Proper Country Name in the Mapping Table, Then  you can use the ApplyMap().

Check the Below Scrip.

Map_Country_Name:
Mapping
LOAD * INLINE [
    CountryName, CountryOriginalName
    Utd.Arab Emir., United Arab Emirates
    Bahráin, Bahrain
    Rep.of Congo, Republic of Congo
    "Cote d'Ivoire", Ivory Coast
    Camerún, Cameroon
    Argelia, Algeria
    Gabón, Gabon
    Guinea Ecuatori, Equatorial Guinea
    Jordania, Jordan
    Níger, Niger
    Omán, Oman
    Sudáfrica, South Africa
];
T1:
LOAD CountryName as CountryName_Old,
  ApplyMap('Map_Country_Name',CountryName,Null()) as CountryName_New,
  Data;
LOAD * INLINE [
    CountryName, Data
    Utd.Arab Emir., 182
    Bahráin, 122
    Rep.of Congo, 193
    "Cote d'Ivoire", 112
    Camerún, 191
    Argelia, 172
    Gabón, 150
    Guinea Ecuatori, 120
    Jordania, 150
    Níger, 119
    Omán, 149
    Sudáfrica, 114
];

[mbp198]

Thanks settu_periasamy for your help

[settu_periasamy]

Hi Mihal,

Do you get the expected result, if so, can you close this thread to mark as helpful/ correct answer?