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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.