Hi Knime experts
I attached the raw data and what I want, if someone can help me .
You didn’t really explain what you wanted
You appear to be grouping by Part Name and/or No. and summing on DGR, but it’s unclear what the underlying logic is. Why are some rows used and others not?
You need to do 3 aggregations using Group by node
Sorry, I didn’t clearly declare what is my question, let me show what my whole data and what I want. Hope this time it’s clear, and thanks in advance.
data.xlsx (13.1 KB)
Thank you for your reply. I am sorry, I didn’t clearly declare what’s my problem, I just resubmit .
So if you first drop the duplicate rows and then group by all the criteria necessary (group no, …) and do the relevant aggregations e.g. sum for numbers, concatenate for text values you should get what you are looking for
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.