topic Need help on ApplyMap in QlikView

Need help on ApplyMap

SatyaPaleti — Wed, 22 Oct 2014 06:42:24 GMT

Hello My Dear Folks,

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

Thank you,

Satya

Re: Need help on ApplyMap

MK_QSL — Wed, 22 Oct 2014 06:45:38 GMT

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

ashfaq_haseeb — Wed, 22 Oct 2014 06:45:42 GMT

Hi,

Check this

Regards

ASHFAQ

Re: Need help on ApplyMap

SatyaPaleti — Wed, 22 Oct 2014 06:53:37 GMT

Thank you Ashfaq

Re: Need help on ApplyMap

ashfaq_haseeb — Wed, 22 Oct 2014 06:55:40 GMT

Hi,

Can you close this thread by selecting appropriate answers

Regards

ASHFAQ

Re: Need help on ApplyMap

SatyaPaleti — Wed, 22 Oct 2014 07:03:09 GMT

Thank you Manish