How can I SUMIF one column into another column?

Laura Daniela

I have 2 datasets, in one I have one column with duplicate IDs and in the other one i have the ID without duplicates, but i want to sum all the candies into the dataset where i don't have any duplicate, how can I do that?

Turribeach

Use Group recipe on the dataset with duplicates, group by the ID column and sum your candies. Then join the output dataset to the dataset without duplicates using the ID so you can add your aggregate column.