ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Summarize / Consolidate Duplicate Values

Isabroks
Átomo

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 RESPUESTAS 2
binu_acs
Polaris

@Isabroks The following settings in the summarize tool should work

image.png

Isabroks
Átomo

It worked!! Thanks :D 

Etiquetas
Autores con mayor cantidad de soluciones