Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am new to Qlikview
What is Applymap where we Use Give an example ?
plz help.
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()
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.
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
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