Get Row(s) Join Table
The Get Row(s) Join Table component retrieves and combines data from multiple DataTables during workflow execution. By matching related records across a shared key column, it returns a single, unified dataset for downstream steps.
a. Automatic Joins: Combines matching records across all selected tables using a common key column.
b. Read-Only Data: Operates strictly on source data without modifying the underlying tables.
Note: This component operates exclusively in Tool Mode. Joins are executed automatically by the workflow execution engine—neither the user nor the agent can directly edit the generated query.
Parameters
| Parameter | Description |
|---|---|
| Select Tables for Join* | Choose two or more DataTables to join. Each table must share at least one common column. Multiple selections are supported. |
| Join Column | Select the column used as the join key. This column must exist in all selected tables (for example, a Name column present in each table). |
| Select JOIN Query |
Provide the JOIN query to determine how the tables are joined and their data combined.
In Tool Mode, the JOIN query is automatically generated and executed by the workflow execution engine. The agent cannot create, modify, or override the query. Table names, aliases, JOIN types, and ON conditions are fully managed internally. |
| Action | Displays the slug name of the selected table(s). This field is visible only when the workflow is running in Tool Mode. |
| Timeout (seconds) | Maximum wait time for the operation to complete before the operation times out. Default: 30 seconds. |
| Retry count | The number of automated retry attempts if the initial request fails. |
| Delay between retries (s) | Wait time between consecutive retry attempts. Default: 1 second. |
| Delay before execution (s) | Time to wait before the component starts processing. Default: 0 seconds. |
| Delay after execution (s) | Time to wait after the component finishes processing. Default: 0 seconds. |
| Continue on Error |
Determines the behavior when an unrecoverable error occurs:
Stop Workflow – Halts workflow execution. Continue – Skips this step and continues without passing the error downstream. Continue Using Error Output – Continues execution and routes error details through the error output handle. |
Output
| Output | Description |
|---|---|
| Join Schema & Template | Shows the structure of the resulting joined table, including column names, data types, and relationships. |
| Data Fetch | Retrieves the actual joined records from the selected tables. |
| Data Frame | Returns the joined data in a structured tabular format for further processing within the workflow. |
