Problem with concatenate

[#1]

Hello, when I use the concatenate, it doesn't combine the fields. It shows Status1 and the name of the second loaded file. Here's a part of my script:

Status1:
 LOAD @1 as mbyte,
 @2 as typ,
 @3 as menge
 FROM
 $(vfrom1)
 (txt, codepage is 1252, no labels, delimiter is ';');
 
 concatenate (Status1)
 LOAD @1 as mybte,
 @2 as typ,
 @3 as menge
 FROM
 $(vfrom2)
 (txt, codepage is 1252, no labels, delimiter is ';');

File looks like this:

5000;typ1;5

Every file has only one line.

best regards

Ingo Placzek

[Anonymous]

Since you have the exact same field structure in the tables they will be automatically concatenated.

[#3]

Johannes Sunden schrieb:

Since you have the exact same field structure in the tables they will be automatically concatenated.

but when i leace the concatenate (Status1) it is seperated with the name of the textfile.

and when i rename it to Status1: the second load is shown as Status1-1

[brenner_martina]

Hi Ingo,

try to enter in one of your load statement to enter a new field, something like this:

Status1:

LOAD @1 as mbyte,

@2 as typ,

@3 as menge

FROM

$(vfrom1)

(txt, codepage is 1252, no labels, delimiter is ';');

concatenate (Status1)

LOAD @1 as mybte,

@2 as typ,

@3 as menge,

'$(vfrom2) As Quelle

FROM

$(vfrom2)

(txt, codepage is 1252, no labels, delimiter is ';');

Greetings from Munich

Martina

[#5]

Hello,

i added @1 a second time as mbytex, but it is also seperated.

[#6 · Accepted solution]

ok, i solved it. I had  Qualify *; at the begin of my script.

Thanks a lot

Ingo

[#7]

How Can I remove dublicate value when use two concate in expression.. 2 is getting time..