We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Summarize / Consolidate Duplicate Values

Isabroks
5 - Atom

Hello team, 

 

I'm trying to consolidate or summarize duplicate values, but not sure how to get this. 

 

This is my original dataset: 

 

EmployeeStoreDistrictCount
1Aa35
2Aa30
3Aa22
1Bb20
1Cc21
2Bb21
2Bb18
3Bb15
2Cc12
3Cc10

 

I want to output the following: 

 

EmployeeStoreDistrictCount
1Aa76
2Aa81
3Aa47
2 REPLIES 2
binuacs
21 - Polaris

@Isabroks The following settings in the summarize tool should work

image.png

Isabroks
5 - Atom

It worked!! Thanks :D 

Labels
Top Solution Authors