topic Problem with concatenate in QlikView

Problem with concatenate

Thu, 26 Jul 2012 06:29:09 GMT

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

Re: Problem with concatenate

Anonymous — Thu, 26 Jul 2012 06:34:55 GMT

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

Re: Problem with concatenate

Thu, 26 Jul 2012 07:14:54 GMT

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

Re: Problem with concatenate

brenner_martina — Thu, 26 Jul 2012 07:18:43 GMT

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

Re: Problem with concatenate

Thu, 26 Jul 2012 07:30:00 GMT

Hello,

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

Re: Problem with concatenate

Thu, 26 Jul 2012 07:37:32 GMT

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

Thanks a lot

Ingo

Re: Problem with concatenate

Mon, 16 Mar 2015 14:35:07 GMT

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