Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
satyapaleti
Contributor II

Need help on ApplyMap

Hello My Dear Folks,

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

Thank you,

Satya

5 Replies
MVP
MVP

Re: Need help on ApplyMap

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

];

Re: Need help on ApplyMap

Hi,

Check this

Regards

ASHFAQ

satyapaleti
Contributor II

Re: Need help on ApplyMap

Thank you Ashfaq

Re: Need help on ApplyMap

Hi,

Can you close this thread by selecting appropriate answers

Regards

ASHFAQ

satyapaleti
Contributor II

Re: Need help on ApplyMap

Thank you Manish

Community Browser