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