Load script Replace comma separated ID with name values

[Vijaikrishna]

I have field with ID values which is comma separated like 1.5,7,10. I need to replace the ID values with names like USA, Canada, Australia, Singapore. How can i do this in load script?

[MayilVahanan]

Hi @Vijaikrishna 

Try like below

Mapping
Load * Inline
[
ID, Country
1,USA
5,Canada
7,Australia
10,Singapore
];

Load Concat(Ctry, ',', ID) as Ctry;
Load ApplyMap('MapCtry', SubField(ID, ',')) as Ctry, ID Inline
[
ID
"1,5,7,10"
];

Replace with inline with ursource.