lookup multiple values

[surajdhall]

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.

[Vegar · Accepted solution]

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;