Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Combining Multiple Rows


Hello all,

Its great to be back on Alteryx, using it in a real world application as opposed to a class setting, but perhaps I have lost a bit and need to freshen up. 


I am analyzing the response rate of mail cards.

I have a list of every order to a show, but some of them have multiple purchases.  So if 12,000 were sent out and I have 3,000 purchases but only 2,500 are unique, it will throw off my rate. 


What I am trying to do is turn: 

John    Smith       2      100 

John    Smith      1        50 



John   Smith       3        150  



Is this possible ? 

Alteryx Certified Partner
Alteryx Certified Partner

Summarise tool


Group by First Name and Last Name. Then choose sum for the other two columns.


haha thank you, I cant believe i forgot that.