topic Re: Apply Map in QlikView

Apply Map

smilingjohn — Wed, 04 Nov 2015 05:19:34 GMT

HI All,

Can someone explain me what is Apply Map is QLikview Script ,

What is mapping used for , It wil be great if anyone can explain with an example .

Thanking you in Advace

Re: Apply Map

Anonymous — Wed, 04 Nov 2015 05:21:32 GMT

Applymap is a mapping function. for more details refer to following thread:

Don't join - use Applymap instead

Re: Apply Map

settu_periasamy — Wed, 04 Nov 2015 05:22:35 GMT

Hi John,

Refer the Below Link:

Apply Map Functions - Sources

Apply map a Simple Example‌

Re: Apply Map

gautik92 — Wed, 04 Nov 2015 05:39:08 GMT

We should use ApplyMap instead of Join

ApplyMap will give better performance

ApplyMap table should be loaded first before it's use.

At the end of the script, this table will disappear !

But we need to make sure that ApplyMap table should have only two column/dimensions.... First should be the lookup dimension and second should be the value we need to get

There should not be any duplication in ApplyMap otherwise it will create duplicated rows..

Example:

ProductTable:

Mapping Load * Inline

[

Product, Name

P1, Product 1

P2, Product 2

P3, Product 3

];

Sale:

Load *, ApplyMap('ProductTable',ProductID, 'Unknown') as PartNameINLINE

[

Customer, ProductID

C1, P1

C2, P2

C4, P4

];

Here ApplyMap will refer to the ProductTable ... It will match ProductID of Sale table with Product of ProductTable and give PartName (2nd Dimension of ProductTable). Wherever there is no Product compare to ProductID, it will give ProductName as Unknown (Third Parameter)....

Re: Apply Map

Kushal_Chawda — Wed, 04 Nov 2015 06:21:41 GMT

See the video to understand more clearly

https://www.youtube.com/watch?v=bH2zzYpZWeQ