topic Re: Merge columns in excel. in QlikView

Merge columns in excel.

agni_gold — Wed, 06 May 2015 10:10:40 GMT

Please help I want all the yellow color values in single column.

Re: Merge columns in excel.

stigchel — Wed, 06 May 2015 10:32:16 GMT

You can maybe use a crosstable in combination with a purgechar function to not load the numbers, if that is what you want like this

CrossTable(Children, Data,1)

LOAD Parent,

PurgeChar(Child,'0123456789') as Child,

PurgeChar(Child1,'0123456789') as Child1,

PurgeChar(Child2,'0123456789') as Child2

FROM

Test11.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Merge columns in excel.

santhoo_san — Wed, 06 May 2015 11:21:23 GMT

you can use cross table as said by Piet above in combination with a purgechar function to not load the numbers, if that is what you want like this

CrossTable(Children, Data,1)

LOAD Parent,

PurgeChar(Child,'0123456789') as Child,

PurgeChar(Child1,'0123456789') as Child1,

PurgeChar(Child2,'0123456789') as Child2

FROM

Test11.xlsx

(ooxml, embedded labels, table is Sheet1);

or use it in the object expression as done in the attachment.