topic Re: Applymap() scenarios in QlikView

Applymap() scenarios

surajap123 — Sat, 02 Nov 2013 10:45:15 GMT

Hi Experts,

I think I know the use of Applymap(), It is used to lookup the date in the mapping table and load into the main table.

I have read a statement that "Applymap() is used to cleanup the data model in Qlikview". I dont understand how Applymap help in to cleanup the data.

1.Could you please help me with an example?

2.What are the general requirements we get to use applymap in your scrips? Please give few examples.

Regards,

Suraj

Re: Applymap() scenarios

Anonymous — Sat, 02 Nov 2013 11:07:59 GMT

Suraj

Does this sample script and attached qvw help explain ?

This could have been done without the applymap() but then you would have had 2 joined tables in your data model, MapColour and Box joined with ColourID.

Having used the applymap() you just have one table and you can also drop the field ColourID.

MapColour:

Mapping LOAD * INLINE [

ColourID, Colour,

1, Red

2, Blue

3, Green

]

;

Box:

LOAD * INLINE [

Box, ColourID

Big, 1

Small, 2

Medium, 1

Squashed ,3

Tiny , 2

];

BoxWithColour :

load

applymap ( 'MapColour', ColourID ) as BoxColour ,

Box

resident Box

;

drop table Box ;

Best Regards, Bill

Re: Applymap() scenarios

vikasmahajan — Sat, 02 Nov 2013 11:34:34 GMT

See Demo Attached with simple example

Re: Applymap() scenarios

fred_s — Sat, 02 Nov 2013 11:50:25 GMT

Applymap helps cleaning up the data model by dropping the table used for mapping.
This means that after the mapping, there's only one table left instead of two connected tables.

Without mapping:

And now the same with Mapping:

Re: Applymap() scenarios

Sat, 02 Nov 2013 16:42:52 GMT

Excellent.

Re: Applymap() scenarios

ngulliver — Sun, 03 Nov 2013 14:23:54 GMT

Hi, Suraj.

I recommend looking at Steve Dark's blog on using ApplyMap:

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Regards,

Neil