> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Join functions

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

| Function               | Description                                                                                                                         |
| :--------------------- | :---------------------------------------------------------------------------------------------------------------------------------- |
| [Lookup](/docs/lookup) | Finds a value in a specified target element column and returns the corresponding row value from another column in that element.     |
| [Rollup](/docs/rollup) | Finds a value in a specified target element column and aggregates all corresponding row values from another column in that element. |