Please check enclosed example.
Also note that
1) Mapping Table should be loaded before the table in which ApplyMap need to be used
2) Mapping Table should be having exactly two columns.
Customer:
Mapping Load *
Inline
[
ID, Name
CID001, Customer001
CID002, Customer002
CID003, Customer003
CID004, Customer004
];
SALE:
Load *,ApplyMap('Customer',Customer_ID,'UNKNOWN') as Name Inline
[
Customer_ID, Product, QTY
CID001, A, 100
CID002, B, 200
CID001, B, 150
CID003, C, 400
CID004, A, 300
CID003, B, 200
CID005, B, 300
];
