Concatenate 2 fields in LOAD statement

Mon, 28 Sep 2009 15:59:25 GMT

Hi community,

I have a problem to concatenate 2 fields into 1 NEW field.

In OL I have found this example:

LOAD Abteilung, concat(Name, '; ') AS Namensliste FROM abc.csv GROUP BY Abteilung

But my statement does not work:

Directory;
LOAD
Equipment_EQUNR,
concat( Bezeichnung_EQKTU, '; ') as Equi_mit_Text
FROM ..\..\Data\EQUI_TEXT.qvd (qvd) GROUP BY Equipment_EQUNR;

The result is: The new field contains only "Bezeichnung_EQKTU", nothing else !!

I want to concatenate the field "Equipment_EQUNR" with "Bezeichnung_EQKTU" into the new field "Equi_mit_Text". What's gong wrong, I'm going crazy ... please give my a hand ...

Concatenate 2 fields in LOAD statement

Mon, 28 Sep 2009 16:05:24 GMT

Hi,

here you go

Equipment_EQUNR &'/' &Bezeichnung_EQKTU as Equi_mit_Text,

that´s all.

Happy qliking!!!

Rainer

Concatenate 2 fields in LOAD statement

Mon, 28 Sep 2009 16:21:38 GMT

Thank's a lot Rainer, it's so easy ...

topic Concatenate 2 fields in LOAD statement in QlikView

Concatenate 2 fields in LOAD statement

Concatenate 2 fields in LOAD statement

Concatenate 2 fields in LOAD statement