Trying to build a string which is the concatenation of all rows in table (only one column)

[balt22]

Hopefully the attached explains my need.  I've looked at batch and iterative macros with no success so far.

In my one column table, there are peoples' names.  I need the concatenation of all of them.  In my example, I have a limited number of rows, but the number will be dynamic, and typically with more rows than in my example.

The top of the image shows a simple text input.  The bottom shows my one-at-a-time multi-row formula to add Row + 1.

Please let me know if this isn't clear enough.

Thanks!

Bryce

[TheOC · Accepted solution]

hi @balt22 

Sorry if im misunderstanding, you may need to provide desired input and output data. However, you can use a summarize tool to concatenate strings in multiple rows:

This will work no matter how many name fields there are.

Hope this helps,
TheOC

[balt22]

OC,

The input is on the left near the top of the image, and the output would be similar to what's on the bottom, but concatenated instead of in multiple columns.

Thanks for the response, I'll look into what you suggested.

Bryce

[balt22]

Oh my gosh, I can't believe I hadn't seen that as an option.  Exactly what I needed, thanks!

Bryce

[TheOC]

hey @balt22 

No problem at all! Glad we were able to work this one out!

Always 50 ways of doing something in Alteryx 😁

Cheers,
TheOC