Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community
i have excel code
=IFERROR(VLOOKUP(CE2,Sheet54!$J$2:$K$59,2,FALSE),"")
I want to convert this Excel formula in Qlikview.
here CE2 is H Final
Expected output:-
V |
Dom |
INT |
CE2 Data:-
H Final |
Asia |
Kerala |
Europe |
Maldives |
Punjab |
Andaman |
Africa |
Hi
Try with Mapping concept to achieve the result.
I think you are looking for the mapping table which is similar to a VLOOKUP.
can you please help me how i map this ?
i try many times but not getting answer.
can you please help me how i map this ?
i try many times but not getting answer.
sheet54 is Different table i map this table but getting error
Load table to lookup using Mapping prefix before load/select statement.
eg
NatInt_Map:
Mapping load Country, V from ....;
After loading the mapping table in the script use the Applymap function when you load the destination table to lookup the first field in the mapping table.
eg Load ...,
[H Final],
Applymap('NatInt_Map', [H Final]) as NatInt,
...;