We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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