Concatenation a column of multiple rows

[Pedro Manuel]

HI all,

I would like to have some help, to do aconcatenation of acolumn that exist in multiple rows and transform in one row.

 

for example :

123 | west Africa | Africa

123 | est Africa | Africa

123 | Central Africa | Africa

 

what I want :

123 | west Africa, est Africa,Central Africa | Africa

[Richard Pobi]

Add a calculated column and use the function, UniqueConcatenate(the col you want to concat)

[Pedro Manuel]

Hi, Can I get a example 

[Richard Pobi]

Col1, Col2, Col3

 

123, west Africa, Africa

 

123, est Africa, Africa

 

123, Central Africa, Africa

 

Insert>Calculated column>UniqueConcatenate(Col2)>Ok

 

After that go to your properties>Columns> and add the new calculated column to your table. If you want to eliminate the duplicate records used the Rowid() function to do that.

[Pedro Manuel]

Unfortnetly I don't have that option in my view. Only appear delete and rename option.

 

 

[Motsu Aboshi]

Would LISTAGG() combined with a GROUP BY clause work for your use case

[Pedro Manuel]

Works Perfect! Thanks foor all!  ;-)