Forum Discussion

Icon for Post Patron rank

Post Patron

5 years ago

Solved

Concate all value in a column

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
5 years ago
ngct1112 , Try concatenatex

concatenatex(Table, Table[Name], ",")
Samarth_18
5 years ago
Hi ngct1112 ,

For getting distinct value you can try below code

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

Thanks

3 Replies

amitchandak
Super User
5 years ago
ngct1112 , Try concatenatex

concatenatex(Table, Table[Name], ",")
- ngct1112
  Post Patron
  5 years ago
  amitchandak , may I ask how could it reserve distinct values only?
  
  I tried this but not working
  = Concatenatex( Table, Distinct(Table(Name), ", ")
  - Samarth_18
    Community Champion
    5 years ago
    Hi ngct1112 ,
    
    For getting distinct value you can try below code
    
    = Concatenatex(Values(Table[Name]),Table[Name], ", ")
    
    Thanks