Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

If there are multiple rows for the same condition, then sum up values of different columns

T_Lina
7 - Meteor

Hi, 

 

could someone help me with the following challenge?

For wherever the ID is the same, I would like to add up the quantites and values as shwon in the "expected output".

I tried the summarize tool but wasn't successful unfortunately. 

 

Thanks a lot!

 

 

T_Lina_0-1618415198160.png

 

2 REPLIES 2
OllieClarke
16 - Nebula
16 - Nebula

Hi @T_Lina can you elucidate on how the summarise tool didn't work? It worked fine when I tried:

OllieClarke_0-1618415748215.png

 

T_Lina
7 - Meteor

Thank you, @OllieClarke !

I made the mistake by not putting both fields as action "sum" but "group by". 

Now it works as you've shown in 🙂 

Labels
Top Solution Authors