group by

[jyothish8807]

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

[#2]

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