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