Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rajveersinghsisodiya
Contributor III
Contributor III

Doubt in Mapping & Applymap

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

Please see http://www.analyticsvidhya.com/blog/2014/07/vlookup-functionality-qlikview/ for detailed explaination

for mapping load and applymap function

Regards

Neetha

View solution in original post

8 Replies
awhitfield
Partner - Champion
Partner - Champion

You just need to ensure the mapping table is created earlier in your load script than the applymap statement.

Not applicable

Hi,

Mapping table should load prior to the table that is using applymap().

Regards,

Joshmi

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

rajveersinghsisodiya
Contributor III
Contributor III
Author

thanks for reply, could you please explain an example for this, it will be very helpful.

Anonymous
Not applicable

Hi,

Please see http://www.analyticsvidhya.com/blog/2014/07/vlookup-functionality-qlikview/ for detailed explaination

for mapping load and applymap function

Regards

Neetha

MK_QSL
MVP
MVP

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..

Not applicable

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.

rajveersinghsisodiya
Contributor III
Contributor III
Author

Hi all thank you so much for your replies, now i understood how to use applymap function.