Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it posssible to use two lines (e.g. from excel) and combine them into one line, which is used as (embedded) label of the field?
E.g.:
Header 1 part a | Header 2 part a | Header 3 part a | Header 4 part a | Header 5 part a |
---|---|---|---|---|
Header 1 part b | Header 2 part b | Header 3 part b | Header 4 part b | Header 5 part b |
Data | Data | Data | Data | Data |
Data | Data | Data | Data | Data |
Data | Data | Data | Data | Data |
Data | Data | Data | Data | Data |
So the two header parts should be combined into one label.
Hi Koen,
I hope I understand it right.. It's a bit complicated but can be done by Rename Fields Using <Map>:
Header:
Crosstable LOAD 0 as Dummy,
Concat(A, ' ', RecNo()) as A,
Concat(B, ' ', RecNo()) as B,
Concat(C, ' ', RecNo()) as C,
Concat(D, ' ', RecNo()) as D,
Concat(E, ' ', RecNo()) as E
FROM
D:\header.xlsx
(ooxml, no labels, table is Tabelle1)
Where RecNo()<3;
FieldMap:
Mapping Load Type, Value Resident Header;
Drop Table Header;
Data:
LOAD A,
B,
C,
D,
E
FROM
D:\header.xlsx
(ooxml, no labels, header is 2 lines, table is Tabelle1);
Rename Fields Using FieldMap;
- Ralf
Hi Koen,
I hope I understand it right.. It's a bit complicated but can be done by Rename Fields Using <Map>:
Header:
Crosstable LOAD 0 as Dummy,
Concat(A, ' ', RecNo()) as A,
Concat(B, ' ', RecNo()) as B,
Concat(C, ' ', RecNo()) as C,
Concat(D, ' ', RecNo()) as D,
Concat(E, ' ', RecNo()) as E
FROM
D:\header.xlsx
(ooxml, no labels, table is Tabelle1)
Where RecNo()<3;
FieldMap:
Mapping Load Type, Value Resident Header;
Drop Table Header;
Data:
LOAD A,
B,
C,
D,
E
FROM
D:\header.xlsx
(ooxml, no labels, header is 2 lines, table is Tabelle1);
Rename Fields Using FieldMap;
- Ralf
Thanks! Works solid.