topic Re: Help on Concatenation/Unique records in QlikView

?

dmohanty — Wed, 04 Jun 2014 10:24:34 GMT

Re: Help on Concatenation/Unique records

tresB — Wed, 04 Jun 2014 10:32:18 GMT

Load

ID,

Concat(Region) as Region

From <> Group By ID;

Re: Help on Concatenation/Unique records

its_anandrjs — Wed, 04 Jun 2014 10:38:17 GMT

Use Concat function and Load your table with the aggregate table

tmp:

LOAD * Inline

[

ID, Region

1, A

1, B

1, C

2, X

2, Y

2, Z

3, M

3, N

4, D

5, E

];

NoConcatenate

Fival:

LOAD

ID,

Concat(Region) as Region

Resident tmp

Group By ID;

DROP Table tmp;

Re: ?

ashfaq_haseeb — Wed, 04 Jun 2014 10:38:27 GMT

Hi try below

temp:

LOAD * Inline [

ID,Region

1,A

1,B

1,C

2,X

2,Y

2,Z

3,M

3,N

4,D

5,E

];

NoConcatenate

Load

ID,

Concat(Region) as NewRegion

resident temp

Group By ID;

drop Table temp;

Regards

ASHFAQ