how to change all record values

[manoj217]

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

[sonkumamon]

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.

[robert_mika]

Create mapping table. Look at ApplyMap function.

[shiveshsingh]

Hi

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
];