PIVOT in BigQuery | C2C Community

PIVOT in BigQuery

Userlevel 7
Badge +65

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.

Read the article here

I love Lak’s articles!

Have you used Pivot in BigQuery?

0 replies

Be the first to reply!