Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;