Create a single record combining values from multiple records

[jackchoy]

Is there a way to create a single record that concatenates the values from multiple records?  Example of what my source data and what my desired result looks like in the attached.

[binuacs · Accepted solution]

@jackchoy 

[atcodedog05 · Accepted solution]

Hi @binuacs 

Another way you can do it

Make sure to use concat and specify | (pipe) as the separator.

Hope this helps : )

[jackchoy]

Thanks!  One minor question.  In the second solution (two back-to-back summarizes), how did you get it to sort in order?  I'm not seeing anything in the configuration.  Or is this just the default behavior (and I couldn't let's say sort in descending order if I wanted to)? 

[atcodedog05]

Hi @jackchoy 

Summarize tool always sorts ascending when you do groupby 🙂 Sadly you cant sort it descending 😅