Label mapping from separate table

aruneshgupta — Thu, 12 Sep 2024 16:04:40 GMT

Hi All,

Can you pleae help me to get Label names from second table to replace IDs in the first table.

Source :

Map of label:

output:

I am having too many colums so lookng some some automated way in the script.

Thanks in advance!

Best Regards,

Arunesh

Re: Label mapping from separate table

Kushal_Chawda — Thu, 12 Sep 2024 18:20:17 GMT

Data:
Load Name,
ID,
CID,
ZID
FROM Source;

map_field:
mapping Load
Field,
Label
FROM Table;

Rename Field using map_field;