How can I SUMIF one column into another column?
Laura Daniela
Registered Posts: 1 ✭
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?
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,138 Neuron
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.