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
19 - Altair

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

Labels