Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to create mapping?

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

3 Replies
oleg_orlov
Contributor

Re: How to create mapping?

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

MVP
MVP

Re: How to create mapping?

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
Valued Contributor III

Re: How to create mapping?

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