Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have doubt regarding mapping and applymap function, its necessary that tables used in mapping and applymap statement must be loaded in application before use in these statements.
Hi,
Please see http://www.analyticsvidhya.com/blog/2014/07/vlookup-functionality-qlikview/ for detailed explaination
for mapping load and applymap function
Regards
Neetha
You just need to ensure the mapping table is created earlier in your load script than the applymap statement.
Hi,
Mapping table should load prior to the table that is using applymap().
Regards,
Joshmi
If you do not want to loose track of mapping tables, create them immediately before first use. For example, a mapping table that is used in only a single LOAD statement, can be created immediately before that particular LOAD statement.
Also good to know: mapping tables with the same name will overwrite each other without so much as a complaint.
thanks for reply, could you please explain an example for this, it will be very helpful.
Hi,
Please see http://www.analyticsvidhya.com/blog/2014/07/vlookup-functionality-qlikview/ for detailed explaination
for mapping load and applymap function
Regards
Neetha
Rules of Mapping Load / Apply Map
1) The Load Statement must start with Mapping Keyword
2) The Mapping Load Table must be loaded before the table where ApplyMap is being used.
3) Mapping Load Table must have only two fields.. First for Comparing....2nd for the result field.
Also, if the comparing field have duplicate values, the first value will be worked for comparing.
Hope this would help..
HI Rajveer,
Applymap() just uses an already created mapping table to map the values.So it is obvious that mapping table to be used in the applymap() should be created beforehand.
Mapping Load / Apply Map versus Left Join
i think this will help you understand it better.
Hi all thank you so much for your replies, now i understood how to use applymap function.