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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Sum duplicate values in a field to be displayed once

Highlighted

Hi,

 

I have a data set that contains two fields: Serial Number and Payment. For example:


Serial Number               Payment

ABC123                           15.01

ABC123                           15.01                            

ABC123                           24.97

DEF456                           18.12

DEF456                           39.90

DEF456                           17.13

 

There are duplicate serial numbers and some have the same payment amount. How can I take the sum payment amount for same serial numbers. So, for ABC123, how can I have that record displayed once with the payment being 54.99?

 

Any help would be greatly appreciated

Alteryx Certified Partner

Hi @Chirag_Gandhi07 

 

Use Summarize Tool.

 

Summarize.PNG

 

Group BY Serial Number and Sum Payment.

 

Cheers,

Labels