How to aggregate records by a value

Five Stars

How to aggregate records by a value

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

 

Sixteen Stars

Re: How to aggregate records by a value

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.

Five Stars

Re: How to aggregate records by a value

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