Label mapping from separate table

[aruneshgupta]

Hi All,

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

Source : 

Name	ID	CID	ZID
Arunesh	1001	2001	3001
Ramesh	2001	3001	40001
Nancy	5001	7001	6001

Map of label:

Field	Label
ID	ScreenId
CID	CountryId
ZID	ZoneID

output:

Name	ScreenId	CountryId	ZoneID
Arunesh	1001	2001	3001
Ramesh	2001	3001	40001
Nancy	5001	7001	6001

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

Thanks in advance!

Best Regards,

Arunesh

[Kushal_Chawda]

@aruneshgupta 

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

map_field:
mapping Load
                       Field,
                       Label
FROM Table;

Rename Field using map_field;