Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 |);
Look into MapSubString() function:
This is from Qlik Sense help, but should work the same way in QlikView
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 |);