Overview
Join is a feature that combines multiple Corvic Tables into a single joined Corvic Table. This feature allows you to merge data from different Corvic Tables using selected columns, enabling you to create unified datasets for analysis, processing, and downstream operations.Category
Corvic Tables - This feature is designed to work with Corvic Tables, enabling you to combine data from multiple tables into a single unified table.Input
Multiple Corvic Tables - The Join feature accepts multiple Corvic Tables as input. Select two or more Corvic Tables from your data room that you want to join together using selected columns.The input requires multiple Corvic Tables with columns that can be used for joining. You’ll need to specify which columns from each table should be used for the join operation.
Output
Joined Corvic Table - The Join feature produces a new Corvic Table containing the combined data from all input tables based on the specified join type and selected columns. The output includes:- Combined Data: All rows from the input tables joined according to the specified join type
- Selected Columns: Columns from all input tables as specified in the join configuration
- Unified Schema: A single schema combining columns from all input tables
The output Corvic Table provides a unified view of your data from multiple sources, making it easy to perform cross-table analysis, create comprehensive datasets, and prepare data for downstream processing or embedding generation.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
inputs | array | Yes | The Corvic Tables to join. Select two or more Corvic Tables from your data room. Specify which columns from each table should be used for joining. |
join_type | selection | Yes | The type of join to perform. Select from: left for left join, right for right join, inner for inner join, or full for full outer join. |
output_name | string | No | Optional custom name for the output joined Corvic Table. If not provided, a default name will be automatically generated based on the input Corvic Table names. |
Join Types
Left Join
Returns all rows from the left table and matching rows from the right table. If there’s no match, the right table columns will contain null values.Right Join
Returns all rows from the right table and matching rows from the left table. If there’s no match, the left table columns will contain null values.Inner Join
Returns only rows that have matching values in both tables. Rows without matches in either table are excluded.Full Outer Join
Returns all rows from both tables. If there’s no match, the columns from the table without a match will contain null values.Usage Example
To use Join in a Data App:- Add multiple Corvic Tables to the Data App canvas
- Click the ”+” button next to one of the Corvic Tables
- Select “Join” from the actions menu
- Select the input Corvic Tables (two or more) that you want to join
- Select the columns from each table that should be used for joining
- Choose the join type (Left, Right, Inner, or Full)
- Optionally provide a name for the output joined Corvic Table
- Run the Data App to execute the join operation
- Review the generated joined Corvic Table containing combined data