Load script Replace comma separated ID with name values

Vijaikrishna — Wed, 03 Mar 2021 08:28:03 GMT

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?

Re: Load script Replace comma separated ID with name values

MayilVahanan — Wed, 03 Mar 2021 08:38:56 GMT

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.

topic Load script Replace comma separated ID with name values in QlikView

Load script Replace comma separated ID with name values

Re: Load script Replace comma separated ID with name values