Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
ok, i solved it. I had Qualify *; at the begin of my script.
Thanks a lot
Ingo
Since you have the exact same field structure in the tables they will be automatically concatenated.
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
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
Hello,
i added @1 a second time as mbytex, but it is also seperated.
ok, i solved it. I had Qualify *; at the begin of my script.
Thanks a lot
Ingo
How Can I remove dublicate value when use two concate in expression.. 2 is getting time..