Sometimes, you might want to reformat a table result so you have separate columns for each unique value. This is called a Pivot table.
What does Pivot do? Pivot changes rows to columns.
I love Lak’s articles!
Have you used Pivot in BigQuery?
PIVOT in BigQuery
Userlevel 7
+58
Be the first to reply!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.