topic Re: Combine two lines into one label from load (e.g. excel) in QlikView

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

Fri, 29 Nov 2013 13:20:57 GMT

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.

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

rbecher — Fri, 29 Nov 2013 13:39:56 GMT

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

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

Mon, 02 Dec 2013 12:47:13 GMT

Thanks! Works solid.