Concatenate 2 fields in LOAD statement

[#1]

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 ...

[#2]

Hi,

here you go

Equipment_EQUNR &'/' &Bezeichnung_EQKTU as Equi_mit_Text,

that´s all.

Happy qliking!!!

Rainer

[#3]

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