OPAL Join Verbs

Verb

Description

exists

Return the rows from the default dataset that have a…

flatten

Given an input of object or array type, recursively…

flatten_all

Given an input of object or array type, recursively…

flatten_leaves

Given an input of object or array type, recursively…

flatten_single

Given an input of object or array type, flatten the…

follow

Return the rows from the additional joined dataset…

fulljoin

Temporal full join, adding new columns in the output…

join

Temporal inner join, adding new columns in the…

leftjoin

Temporal left join, adding new columns in the output…

lookaround_join

Lookaround join is a type of inner join. Where this…

lookup

Find matching rows in a resource, making new columns…

surrounding

Rows from the “right” dataset that fall within the…

union

Create a new event dataset, consisting of events…

update_resource

Update the current resource by merging an event (or…