group by

jyothish8807 — Wed, 23 Apr 2014 09:59:08 GMT

Hello All,

I am trying to group an ID and consolidated all the information corresponding to it into a single entry.

ID Entry

1 A

1 B

1 C

2 AS

2 BC

2 QW

Now i want my output table like the:

ID Entry

1 A_B_C

2 AS_BC_QW

Thanks and Regards

Jyothish KC

Re: group by

Wed, 23 Apr 2014 10:04:33 GMT

Here you go..

Load ID, Concat(Entry,'_') as Entry

Group by ID;

LOAD * INLINE [

ID, Entry

1, A

1, B

1, C

2, AS

2, BC

2, QW

];

Thanks,

Prabhu