Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.