This simple example illustrates how the following functions operate on nested data.
ARRAYCONCAT- Concatenate multiple arrays together. See ARRAYCONCAT Function.
ARRAYINTERSECT- Find the intersection of elements between multiple arrays. See ARRAYINTERSECT Function.
ARRAYCROSS- Compute the cross product of multiple arrays. See ARRAYCROSS Function.
ARRAYUNIQUE- Generate unique values across multiple arrays. See ARRAYUNIQUE Function.
Code formatting has been applied to improve legibility.
You can apply the following transforms in the following order. Note that the column names must be different from the transform name, which is a reserved word.Results:
This page has no comments.