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
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.