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