look for same name in column A, if equal sum up the amounts

Hi, I am beginner in Alteryx Designer.

I'm working on a spreadsheet with name on column A and amount on column B.

How do I get Alteryx do the following:

Look up column A and sum up column B.

example of raw data sheet

apple	10
banana	11
orange	35

banana	40
orange	10
banana	50

output

apple	10
banana	101
orange	45

Thanks in advance.

Preparation

Accepted answers

AngelosPachis

Hi @LukeCa ,

Use a summarize tool (Transform tool palette) and Group By Column A and Sum Column B

Cheers,

Angelos

example.yxmd

All comments

AngelosPachis

Hi @LukeCa ,

Use a summarize tool (Transform tool palette) and Group By Column A and Sum Column B

Cheers,

Angelos

example.yxmd

atcodedog05

Hi @LukeCa

Here is a resource on summarize tool which summarizes data for you like a pivot table : https://community.alteryx.com/t5/Interactive-Lessons/Summarizing-Data/ta-p/424417#done

Hope this helps 🙂

LukeCa

thank you for answer. I got it to work now.

just an additional question.

if have 2 files and I need to compare it. how do I go about doing it.

file 1 - Source A

Apple	100
Banana	200

file 2 - Source B

Apple	100
Banana	200

Output

Apple	100	100	valid
Banana	200	200	valid

Orange

100

200

invalid

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703