Join functions | Sigma Documentation

Join functions retrieve data from target elements based on related columns in the local and target elements.

Function	Description
Lookup	Finds a value in a specified target element column and returns the corresponding row value from another column in that element.
LookupMatchNulls	Finds a value in a specified target element column and returns the corresponding row value from another column in that element, matching null join keys.
Rollup	Finds a value in a specified target element column and aggregates all corresponding row values from another column in that element.