topic How to get values using lookup Table in QlikView

How to get values using lookup Table

Fri, 04 Dec 2015 07:39:09 GMT

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 — Fri, 04 Dec 2015 17:00:38 GMT

Look into MapSubString() function:

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

sunny_talwar — Fri, 04 Dec 2015 17:03:40 GMT

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 |);