What is Applymap where we Use Give an example ?

[jonesbrown]

Hi All

I am new to Qlikview

What  is  Applymap where we Use Give an example ?

plz help.

[ramasaisaksoft]

Hi Jones,

when ever we need to use VLOOKUP() in QlikView we will use APPlyMap()

Ex:-

T1:

Mapping Load

EID,

Ename

from......;

T2:

Load

A,

B,

C,

ApplyMap('T1',EID,Null()) as "Employeename",

D

From ......;

So after execution of script at the end Automatically T1 table will drop.

Conditions while we are using ApplyMap()

1. Before using ApplyMap() there should be Mapping Load table Exist
2. Mapping Load table must should have only 2 dimensions in that table. (Ex: EID, EName) 

Please go with some other links mentioned below for more understand

https://community.qlik.com/t5/QlikView-App-Development/quick-applymap-example/td-p/515616

if you still not clear reach out me on  +91 8376 964 364.

[Surya]

Hlo.,

when ever we need to use applymap in Qlikview

w e having certain rules .,mainly applymap use to map field to another table like VLOOKUP()

..

we are using mapping as prefix for loading table it is always return in before applymap

like ..

map:

mapping load  a,b

from path;

load *,

applymap('map',a) //here map is above table name and a is common field from 2 table 

....

in mapping table always having 2 fields only.

1. Key field

2.Mapping field

......

and the main diference of left join and applymap is 

.........................................

Sno,Name

1,surya

2,Jones

3,Vinayak

1,Prakash

........................

when you do applymap 

1,surya

2,Jones

3,Vinayak

1,surya

when you do left join

1,surya

2,Jones

3,Vinayak

1,Prakash

[Brett_Bleess]

Jones, have a look at the following Design Blog link, hopefully that will get you what you need on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Regards,
Brett