topic Re: how to change all record values in QlikView

how to change all record values

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

i have two tables for both of tables have common field country but record values for one table shows India another table shows Ind i want to change Ind as India similarly all the country names need to change how it is possible

Re: how to change all record values

sonkumamon — Sun, 23 Jul 2017 04:24:24 GMT

Hi manoj

Can you copy the script here?

It looks like you should use a mapping inline table.

Try:

map_Countries:

MAPPING

LOAD * INLINE [

Country1, CountryName

Ind, India

US, United-States

Irl, Ireland

];

And use it to map Table 2 values.

Re: how to change all record values

robert_mika — Sun, 23 Jul 2017 06:21:20 GMT

Create mapping table. Look at ApplyMap function.

Re: how to change all record values

shiveshsingh — Mon, 24 Jul 2017 06:17:26 GMT

use this

TEST: MAPPING LOAD * INLINE
[COUNTRY, DESC
IND,INDIA
JAP,JAPAN
RUS,RUSSIA];

COUNTRY:LOAD ApplyMap('TEST',COUNTRY,'NA') AS COUNTRY,CITY INLINE [
COUNTRY, CITY
IND,NEW DELHI
IND,LUCKNOW
IND,PUNE
JAP, TOKYO
RUS,MOSCOW
UK,LONDON
];