community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Combining Multiple Rows

Asteroid

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 

 

Into:

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.

Asteroid

haha thank you, I cant believe i forgot that. 

Labels