How to create mapping?

[#1]

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

[oleg_orlov]

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

[MK_QSL]

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

[ngulliver]

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