Add sum of values in one column based on the value in another column

Hi there,

I have an Excel file which looks like this, without the "added values" column:

What I want to do in Alteryx is: Add all of the values in the "values" column for each unique number in the "numbers" column.

The output should look something like the "added values" column, where all the values for each unique number have been added together.

Appreciate any assistance!

All the best,

Jacob

Common Use Cases

Accepted answers

AngelosPachis

In that case you will have to tweak your multi-row formula tool to account for the fact that the dataset does not start with "0", as you correctly pointed out.

Try the following formula in your multi-row formula tool. It should do the job.

Annotation 2020-07-14 115658.png

Let me know if you have any questions on the above. If that solution answers your question, please mark it as correct to close this thread 🙂

Cheers

example_v2.yxmd

All comments

AngelosPachis

Hi @JacobTwill

Try using the summarize tool. You should group by Numbers and sum values.

Annotation 2020-07-14 103807.png

I think this will give you what you are looking for.

JacobTwill

Hi Angelos,

This is definitely what I need - thank you!

However, I now notice that my dataset does not list all the numbers for each row.

Instead, the "numbers" column contain nulls under each unique value.

Is there a way to replace the [nulls] with the numbers 0, 1, 2, and 3 respectively?

Appreciate the help!

Best regards

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703