Applymap

[#1]

Hi every one,

I want to know about usage of applymap and what is the relation between applymap and mapping load?

When we go for applymap and why we are using mapping load?

Please help me in this if anyone knows.

[ashfaq_haseeb]

Hi,

Please refer the below post from henric.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap

Hope it help.

Regards

ASHFAQ

[MK_QSL]

ApplyMap function is used to lookup and find value from one table to other.

ApplyMap table need to be load using Mapping Load......

There should be only two field... 1st for lookup and 2nd for result...

There should not be any duplicate values in Mappling Load Table.

Mapping Load is to Load Table and ApplyMap is to get the values from Mapping Load Table..

End of the scrip

Example given below...

Consider that you have Customer and Country in one table and Sales in another table.

You want Country in Sales Table... Write below in script...

CustomerTable:

Mapping Load * Inline

[

  Customer, Country

  A, Germany

  B, France

  C, Italy

  D, Poland

  E, Spain

  Z, UK

];

Sales:

Load *,

  ApplyMap('CustomerTable', CustomerID, 'Unknown') as CustomerCountry

Inline

[

  CustomerID, Month, Sales

  A, Jan, 100

  B, Jan, 200

  C, Jan, 300

  D, Feb, 150

  E, Mar, 200

  F, Apr, 100

  A, May, 140

  D, May, 80

  E, May, 100

  F, Jun, 150

];

[ngulliver]

Hi, Sattish.

It is certainly worth learning how to use an ApplyMap as they are incredibly useful

Have a look at this blog explaining ApplyMap.

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Regards,

Neil