topic Re: Concatenation in QlikView

Concatenation

Tue, 30 Aug 2016 10:07:50 GMT

I am looking for a load script to generate the desired output:

Input Data

Column1 Column2

10 B

10 A

20 P

10 C

20 R

10 D

20 Q

Output Data

Column1 Column3

10 A

10 AB

10 ABC

10 ABCD

20 P

20 PQ

20 PQR

Can someone plz help on this?

Re: Concatenation

antoniotiman — Tue, 30 Aug 2016 10:27:47 GMT

Temp:
LOAD * Inline [
Column1 Column2
10 B
10 A
20 P
10 C
20 R
10 D
20 Q
](delimiter is spaces);

NoConcatenate
LOAD Column1,
If(Column1=Peek(Column1),Peek(Column2))&Column2 as Column2
Resident Temp
Order by Column1,Column2 ;

DROP Table Temp;

Re: Concatenation

Tue, 30 Aug 2016 11:26:24 GMT

But I see some different Output with this code :

Temp:

LOAD * Inline [

Column1 Column2

10 B

10 A

20 P

10 C

20 R

10 D

20 Q

](delimiter is spaces);

NoConcatenate :

LOAD Column1,

If(Column1=Peek(Column1),Peek(Column2))&Column2 as Column2

Resident Temp

Order by Column1,Column2 ;

plz suggest :

Re: Concatenation

antoniotiman — Tue, 30 Aug 2016 12:13:45 GMT

Drop Table Temp !!!!!!!

Re: Concatenation

Tue, 30 Aug 2016 12:17:32 GMT

That's not giving any record in the Output...!!

Re: Concatenation

MarcoWedel — Wed, 31 Aug 2016 22:06:31 GMT

delete the colon after NoConcatenate as well.

(Otherwise 'NoConcatenate' is interpreted as table name and the subsequent load autoconcatenated to and droped with table 'Temp'.)

hope this helps

regards

Marco

Re: Concatenation

Thu, 22 Sep 2016 12:51:43 GMT

Thanks for ur reply.

It has worked for me...!!