Join

Join with another file/table

What It Does

Join combines data from two files based on matching column values. Like VLOOKUP in Excel but more powerful. Supports inner, left, right, and full outer joins.

How to Use It

Opening the Panel

Click the + button in the toolbar or press the operation picker, then search for "Join". It's in the Data group.

Configuration

Field	Type	Required	Description
`Join table`	File/table select	Yes	The second file to join with
`Join type`	Select	Yes	INNER, LEFT, RIGHT, FULL OUTER
`Left column`	Column select	Yes	Column from current file
`Right column`	Column select	Yes	Matching column from second file

SQL Generated

SELECT a.*, b.department FROM orders a LEFT JOIN employees b ON a.employee_id = b.id

Try this operation →

Notes

Null values are handled gracefully - operations skip or preserve nulls where appropriate.
You can edit any pipeline step by clicking on its card to re-open the panel with the same settings.
The SQL preview shows exactly what will execute - inspect it before applying.

Related Operations

Unnest - Explode delimited column into rows
Fill Missing - Fill null values
JSON Extract - Extract data in JSON format into columns