Simplest way to get the aggregate value from one dataset, and bring it in to another

Noah
Noah Registered Posts: 43 ✭✭✭✭

I have dataset A and dataset B. I need the aggregate total from one column called "Total Commission" from B. I want to bring it into A and populate a single column with that value.

I know I can do this in Python with two dataframes and I know I can do this with a join if I create a join key in the datasets. Is there a simpler way to do this than either of those two options?

Thanks!

Answers

Setup Info
    Tags
      Help me…