How to get values using lookup Table

[#1]

Hi All,

I have Look up table as follow:

I have to Populate the Product Values in Relate table using Lookup:

Please suggest solution regarding this.

[sunny_talwar]

Look into MapSubString() function:

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/MappingFunctions/Ma...‌

This is from Qlik Sense help, but should work the same way in QlikView

[sunny_talwar · Accepted solution]

Try this script:

Mapping:

Mapping

LOAD * Inline [

LOOKUP, PRODUCT

1, P1

2, P2

3, P3

];

Table:

LOAD IDs,

  MapSubString('Mapping', IDs) as Product;

LOAD * Inline [

IDs

1,2,3

1,2

2,3

] (delimiter is |);