topic How to aggregate records by a value in Talend Studio

How to aggregate records by a value

rafaaaaa — Sat, 23 Dec 2017 13:49:40 GMT

I am creating a job in talend DI

I have an output table with that output

ID,SUbId,date

1,0,12/12/2017

2,0,12/12/2017

0,1,12/12/2017

0,2,12/12/2017

I need the output to be like that

1,0,12/12/2017

2,1,12/12/2017

2,2,12/12/2017

Anonymous — Sun, 24 Dec 2017 16:06:49 GMT

You need to explain how these records are grouped. I may be missing something obvious, but I can't see how these are grouped or aggregated.

rafaaaaa — Sun, 24 Dec 2017 18:16:50 GMT

Hi,

they are grouped by ID

you can find that the person with Id = 2 has three rows one with sub_id = 0 , 1 and 2

so if the person has not any sub_id so he will have one record with his ID

but if he has at least one Sub ID i don't want to see the value of zero and he ID should be attached with each Sub ID

Raef