Tag: string-function

String Aggregtion to create pivot columns in Big Query

google-bigquery pivot sql string-function

I am trying to implement this exact solution linked below, but it seems GROUP_CONCAT_UNQUOTED is no longer a valid BQ function. Is there a solution to this that works in 2020? p.s. I would have just …