concatenate all the rows of a column in a single cell

Looker Q&A Looker Studio
1

Hello,
Is it possible to concatenate all the rows of a column in a single cell with a comma to separate the elements? I can only do this for 2 cells in a single column.

Thanks for your help,

Thierry

2

Hi Thierry_D,

unfortunately, in Looker Studio, there is no way to achieve something like STRING_AGG in BigQuery which would be what you are looking for.

What type of datasource are you using? If you use a Looker model as your datasource, you could create a measure of type: list in LookML and use that.

Best

Marc