?

[dmohanty]

..

[tresB]

Load

          ID,

          Concat(Region) as Region

From <> Group By ID;

[its_anandrjs]

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;

[ashfaq_haseeb]

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