Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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..
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