jeudi 28 juillet 2016

Unwind array values in BigQuery/SQL

I was trying to unwind array values to different rows in BigQuery/ PSQL. This is what I have right now :: Col_1 col_2 A array: {1,2,3,4,5} B array: {1,2,3} C array: {4,5,6} I want to convert this as shown below in BigQuery. A 1 A 2 A 3 A 4 A 5 B 1 B 2 B 3 C 4 C 5 C 6

Aucun commentaire:

Enregistrer un commentaire