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

[LukeCa]

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.

[AngelosPachis · Accepted solution]

Hi @LukeCa ,

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

Cheers,

Angelos

[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

[AngelosPachis]

@LukeCa you can use a join tool to match values from column A from the first input to values from column A from the second input and then compare the specific values with a formula tool. You can either check if all combinations from both columns match with the join tool.

I have created some ways in a workflow that you can explore. Please let me know if something is not clear.

Cheers,

Angelos

[LukeCa]

thank you so much. 

just one more question i hope: how do I remove the negative sign in front of the number.

input

Apple	-100
Banana	-200

Output

Apple	100
Banana	200

Thanks in advance

[AngelosPachis]

Hey @LukeCa ,

You can use a formula tool with the ABS(x) expression, where x is the column name of the field with the numeric values.

That will look at the absolute value in those columns, effectively removing the - signs