tag/rename using applymap

[srihitha]

Hi ,

Can someone quote a detailed sample script of how to tag and rename fields using applymap .

I am aware of the below syntax but i want it to be used in the script

Rename/tag field field1 using mapname;

[vinieme12]

Map_NewNames:

Mapping Load * Inline [

Old name,Newname 

Year,YearIs 

Date,DateIS 

Month,MonthIs

]; 

Fact:

Load * Inline [

Date,Year,Month,Sales

2022-01-01,2022,Jan,1000

2022-02-01,2022,Feb,2000

]; 

Rename fields using Map_NewNames;

Exit Script;

Important thing to note with mapping table 

1) there can only be two columns in a mapping table 

2)first column must always be the lookup value