Forum Discussion
EaglesTony
Post Prodigy
Post ProdigyHow can I combine on a group by ?
hi,
I have the following:
Application Code Info
401 Doe, John|
401 Doe, Jane|
402 Trust, Frank|
I need it:
Application Code Info
401 Doe, John|Doe, Jane|
402 Trust, Frank|
I'm thinking a group by as some sort ?
Hi EaglesTony
while grouping, you can simply pull the column that you want _[ColumnName] which will convert it into a list. Post this, just wrapping it around Text.Combine() shall do the trick. Thanks
