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 under the hood

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

Try this operation →

Related Operations

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