Combine values from column of list of records

[karimm]

Hi there

I have a table containing a column named "apps".

Each cell in the column contains a list of one of more records, where each record represents an app.

The record has a field named "name" containing the app name.

I would like to transform each list to a string that is the concatenated list of app names in that cell.

I could expand to new rows and then group by all other columns, but i believe there is a more elegant solution that is easier to maintain.

EXAMPLE:

apps

-----

list {[id=1,name=app1]}

list {[id=1,name=app1],[id=2,name=app2])

Desired result

apps

----------------

app1

app1,app2

Please help 🙂

P.S. i have seen the post below, but couldn't convert the solution to be list based.

Concatenate values from child records while expanding from merged query 

[mahoneypat · Accepted solution]

You can use an expression like this in a custom column

= Text.Combine(List.Transform([ColumnWithList], each _[name]), ", ")

Pat

[karimm]

Thank you so much!

I actually tried something very similar but I was trying to do the whole transformation in the same column without creating a new custom column.

Thanks again!