There is a table in BigQuery that contains 2 REPEATED(arrays) type of columns, enterded_date and status.
Table in BigQuery:
Is it possible to make a query that returns rows instead?
Like this:
Advertisement
Answer
Consider below approach
select t.* except(entered_date, status), entered_date, status from your_table t, t.entered_date as entered_date with offset join t.status as status with offset using(offset)
if applied to sample data in your question – output is