Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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
6 - Meteoroid

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
18 - Pollux

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

Labels