Join functionsAsk a question|Copy page|View as Markdown|More actionsJoin functions retrieve data from target elements based on related columns in the local and target elements. FunctionDescriptionLookupFinds a value in a specified target element column and returns the corresponding row value from another column in that element.RollupFinds a value in a specified target element column and aggregates all corresponding row values from another column in that element.