topic Re: Doubt in Mapping & Applymap in QlikView

Doubt in Mapping & Applymap

rajveersinghsisodiya — Mon, 23 Feb 2015 12:21:11 GMT

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.

Re: Doubt in Mapping & Applymap

awhitfield — Mon, 23 Feb 2015 12:24:21 GMT

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

Re: Doubt in Mapping & Applymap

Mon, 23 Feb 2015 12:28:03 GMT

Hi,

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

Regards,

Joshmi

Re: Doubt in Mapping & Applymap

Peter_Cammaert — Mon, 23 Feb 2015 12:28:41 GMT

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.

Re: Doubt in Mapping & Applymap

rajveersinghsisodiya — Mon, 23 Feb 2015 12:36:33 GMT

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

Re: Doubt in Mapping & Applymap

Anonymous — Mon, 23 Feb 2015 12:43:24 GMT

Hi,

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

for mapping load and applymap function

Regards

Neetha

Re: Doubt in Mapping & Applymap

MK_QSL — Mon, 23 Feb 2015 14:04:39 GMT

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

Re: Doubt in Mapping & Applymap

Mon, 23 Feb 2015 14:15:11 GMT

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.

Re: Doubt in Mapping & Applymap

rajveersinghsisodiya — Tue, 24 Feb 2015 04:58:06 GMT

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