When handling data from APIs, the Unnest operation can come in handy.

It is equivalent to the Unnest operator in SQL.

If one of your columns is an array (or a string with some commas in it), it will split that column and return as many rows as there were elements in the array (with all other columns being equal)

For example, it will turn the table on the left into the table on the right.


The Unnest operation will also work if your variable is text with different values separated by a comma.
Was this article helpful?
Thank you!