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
x
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