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.

summarize tool configuration

L_Gordon
8 - Asteroid

configure sumarize tool to concatenate all values from a field

2 REPLIES 2
rkakde
8 - Asteroid

Hello!

 

You can summarize on a field (with or without a group by on another field) to concatenate on the contents. You can find the concatenate option at Add->String->Concatenate

 

You might have to use a formula tool and replace all the commas with spaces or remove them if you want. Here is a sample work flow that concatenates a field and then removes the commas after concatenation. (Also attached the yxmd file). I have used RegExReplace in the formula tool to remove the commas.

Summarize Concatenate.png

Hope that helps!

Rishi

Rishi
apathetichell
20 - Arcturus

And if your original field isn't a string - convert it first to a string (ie if you want to concatenate numbers)...

Labels
Top Solution Authors