Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Concatenate multiple data rows - Please help!!!

sagar_agarwal
8 - Asteroid

Hello All - I need some help figuring out in what I think is really challenging. I need to concatenate the "Menu Path" symbol present in different rows based on the value of "Symbol". Please refer to below screenshot which is a sample of what I want.

 

Alteryx Concatenation.PNG

3 REPLIES 3
Federica_FF
11 - Bolide

Hi,

 

you can use a Summarize tool. Group by Symbol - Menù Path, go in the category Strings and choose "Concatenate", setting comma+space as delimiter

sagar_agarwal
8 - Asteroid

This worked like charm - thank you so much!

neeleshapatil1
8 - Asteroid

Is there any limitation on the size of concatenated string? How to overcome such limitation in case of too long string exceeding size limit? 

Labels