# Join Functions Join functions retrieve data from target elements based on related columns in the local and target elements. | | | | --------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------- | | [lookup](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/join-functions/lookup "mention") | Finds a value in a specified target element column and returns the corresponding row value from another column in that element. | | [rollup](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/join-functions/rollup "mention") | Finds a value in a specified target element column and aggregates all corresponding row values from another column in that element. |