BigQuery - concatenate array of strings for each row-CodePudding

Home > front end > BigQuery - concatenate array of strings for each row

BigQuery - concatenate array of strings for each row

Time：03-16

Given this input:

Row     id      app_date    inventor   country
1       id_1    01-15-2022  Steve       US
                            Ashley      US
2       id_2    03-16-2011  Pete        US
                            Jamie       US
                            Mary        FR

I need to concatenate inventor strings for each id, like so:

Row     id      app_date    inventors   
1       id_1    01-15-2022  Steve, Ashley
2       id_2    03-16-2011  Pete, Jamie, Mary

Following

Page link：https//www.codepudding.com/frontend/336858.html

Prev:return product name in new column for each row based on if an individual product column in each row

Next:How to get ids of the objects from django model?

Tags：

sql

google-bigquery

unnest

Links：
CodePudding