Need help on ApplyMap

[SatyaPaleti]

Hello My Dear Folks,

Could any one of you can give information on ApplyMap function with examples

Thank you,

Satya

[MK_QSL]

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

];

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[SatyaPaleti]

Thank you Ashfaq

[ashfaq_haseeb]

Hi,

Can you close this thread by selecting appropriate answers

Regards

ASHFAQ

[SatyaPaleti]

Thank you Manish