lookup multiple values

surajdhall — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have data that i want to bring into sales table using applymap. The data is many-to-1 relationship with sales table ie multiple code field value maps to single sales rows. Since applymap 1-1 mapping, we want to have multiple output values into single value as comma separated.

Output expected-

Code_Map:
Mapping
LOAD
key,
Code
FROM
[codes list.xls]
(biff, embedded labels, table is Lookup$);

Sales:
LOAD key,
Sales,
ApplyMap('Code_Map',key) as CodeList
FROM
[codes list.xls]
(biff, embedded labels, table is Sales$);

Thanks!

Please help.

Re: lookup multiple values

Vegar — Wed, 15 May 2019 17:28:36 GMT

You will need to adjust the map.

Code_Map:
Mapping
LOAD
key,
Concat(Code, ',')
FROM
[codes list.xls]
(biff, embedded labels, table is Lookup$)

Group by key;

topic lookup multiple values in QlikView

lookup multiple values

Re: lookup multiple values