Get Row(s) Join Table

Estimated reading: 2 minutes

The Get Row(s) Join Table component allows you to retrieve and combine data from multiple Data Tables during workflow execution.

Use this component when you need to merge data from two or more tables based on a common column. By selecting a shared column that exists in all chosen tables, the component matches related records and returns the combined (joined) output.

Note: This component works exclusively in Tool Mode.

Parameters

*Required Fields
Parameter	Description
Select Tables for Join*	Choose two or more tables that you want to join. Each table must have at least one column in common. Note: This field supports multiple selections.
Join Column	Select the column name that will be used to join the tables. This column must exist in all selected tables. Example: ‘Name’ column present in both tables.
Select JOIN Query	Provide a complete PostgreSQL SELECT query that includes JOIN conditions between the selected tables. Note: Table names, aliases, JOIN types, and ON conditions are system-defined and cannot be modified in the query.
Action	Displays the slug name of the selected table(s). Note: This field is visible only when the workflow is running in Tool Mode.

Output

Output	Description
Join Schema & Template	Displays the structure of the new table created after joining two or more tables, including all column names and data types.
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.

Get Row(s) Join Table

Parameters

Output

Get Row(s) Join Table

CONTENTS