Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello My Dear Folks,
Could any one of you can give information on ApplyMap function with examples
Thank you,
Satya
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
];
Hi,
Check this
Regards
ASHFAQ
Thank you Ashfaq
Hi,
Can you close this thread by selecting appropriate answers
Regards
ASHFAQ
Thank you Manish