topic Re: How can I concat Subfield ? in QlikView

How can I concat Subfield ?

suzel404 — Mon, 07 Mar 2016 22:55:56 GMT

Hi all,

I have a Label field like : 000 - Problem Network + Operational + Echange Control Balance for the ID 16.

How can I obtain the field Label like this (in column not inline)

Label:

Problem Network

Operational

Echange

Debit

Echange Control Balance

Echange Fees

Echange OFF

Echanges ON

Thanks for your help.

Regards,

swuehl — Mon, 07 Mar 2016 23:06:22 GMT

Maybe like

LOAD

ID,

Label,

Trim(Subfield(Replace(Label, '-','+'),'+')) as SUB

FROM ConcatSubfield.xlsx (ooxml, embedded labels, table is Sheet1);

suzel404 — Mon, 07 Mar 2016 23:59:34 GMT

Hi Swuehl,

It is exactly what I need.

Thank you !!