Status Update
No update yet.
Comments
ju...@gmail.com
is there any news on this?
vi...@google.com
so...@google.com
You can pivot already, e.g. using a conditional aggregation: https://stackoverflow.com/questions/50796224/pivot-rows-in-big-query . Client tools such as Sheets, Excel, Data Studio, etc. are almost always in a better position to pivot the data returned by BigQuery since if you want to do it in a single BigQuery query, you need to provide the list of values and column names to pivot.
xa...@google.com
ta...@gmail.com
I had to implement a solution to pivot 300 rows into columns. We need a better way to pivot rows. Conditional aggregation or sql generators are cumbersome and error-prone.
Description
Build: AI-201.8743.12.41.6858069, 202009231536,
AI-201.8743.12.41.6858069, JRE 1.8.0_242-release-1644-b01x64 JetBrains s.r.o, OS Windows 10(amd64) v10.0 , screens 1920x1080, 1920x1080
AS: 4.1; Kotlin plugin: 1.3.72-release-Studio4.1-5; Android Gradle Plugin: 3.1.0; Gradle: 6.1.1; NDK: from local.properties: 21.3.6528147, latest from SDK: 21.3.6528147; LLDB: pinned revision 3.1 not found, latest from SDK: (package not found); CMake: from local.properties: (not specified), latest from SDK: (not found), from PATH: (not found)
IMPORTANT: Please read