I am creating a job in talend DI
I have an output table with that output
I need the output to be like that
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.
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
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.