Concate all value in a column

[ngct1112]

Hi All,

May I know how could I concate all values in the same column so that I could put in the card?

Great thanks.

Name

David

Ray

Tony

Sally

Kelvin

To

David, Ray, Tony, Sally, Kelvin

[amitchandak · Accepted solution]

@ngct1112 , Try concatenatex

concatenatex(Table, Table[Name], ",")

[amitchandak · Accepted solution]

@ngct1112 , Try concatenatex

concatenatex(Table, Table[Name], ",")

[ngct1112]

@amitchandak , may I ask how could it reserve distinct values only?

I tried this but not working

= Concatenatex(
Table, Distinct(Table(Name), ", ")

[Samarth_18 · Accepted solution]

Hi @ngct1112 ,

For getting distinct value you can try below code

= Concatenatex(Values(Table[Name]),Table[Name], ", ")

Thanks