In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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
binu_acs
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