How can I SUMIF one column into another column?

Laura Daniela
Laura Daniela Registered Posts: 1
edited August 7 in Using Dataiku

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
    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.

Setup Info
    Tags
      Help me…