We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Group records by 50 and insert , between each number

ewassell
8 - Asteroid

I have a file of numbers that need to be grouped by 50 with a comma between each number.  Doesn't seem hard but I can't figure it out.  Input tab shows all the numbers and output tab shows how output should look.

2 REPLIES 2
RaphaelSilva
9 - Comet

You can achieve that using multi-row tool to identify the groups, then use summarize tool to concatenate values in a group


ewassell
8 - Asteroid

Thanks so much! This is perfect!

Labels
Top Solution Authors