Alteryx Designer Desktop Discussions

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

summarize tool configuration

L_Gordon
Astéroïde

configure sumarize tool to concatenate all values from a field

2 RÉPONSES 2
rkakde
Astéroïde

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
Altaïr

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

Étiquettes