Combine two lines into one label from load (e.g. excel)

[#1]

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.

[rbecher · Accepted solution]

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

[#3]

Thanks! Works solid.