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