How to aggregate records by a value

rafaaaaa · ‎2017-12-23

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 · ‎2017-12-24

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 · ‎2017-12-24

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

BR

Raef