topic Re: How to create mapping? in QlikView

How to create mapping?

Wed, 30 Apr 2014 04:56:10 GMT

hi guys,

I saw a mapping load video in you tube after I created mapping load function in qlikview as it is like you tube video but it did not work

[ when I reload the script it shows an error LIKE Mapping Requires 2 -Column input].I do not know How to create mapping load function like you tube video. I attached all scripting images and MS- excel files below this box.please tell me out how to create mapping load.

Regards:

madhu

Re: How to create mapping?

oleg_orlov — Wed, 30 Apr 2014 05:06:59 GMT

Hi!

Mapping table must have only 2 fields.

Example:

Map:

Mapping

Load * Inline [

x, y

1, 2

2, 4

3, 6

];

In your case you have mapping table "Promotions_map" which contains 3 fields instead 2.

Regards,

Oleg

Re: How to create mapping?

MK_QSL — Wed, 30 Apr 2014 05:58:39 GMT

You can't keep three fields in Mapping Load Table...

Consider that you have three fields

Matching or Lookup fields = Field1, Field2

Result Field = Field3

Try to combine as Below

TempMapping:

Mapping Load

Field1&Field2,

Field3

From....

Now in your main table use as below

ApplyMap('TempMapping',YourField1&YourField2,'Unknown') as YourFieldName3

Hope this helps..

Re: How to create mapping?

ngulliver — Tue, 06 May 2014 08:36:24 GMT

Hi, Madhu.

If you want a bit more information on how to use ApplyMap, have a look at this blog:

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

It will help explain how to construct an ApplyMap and when to use it.

Cheers,

Neil