← All tools

Data Join Playground

Join typed scalar keys without coercion. SQL-like null keys never match; duplicate keys produce all matching pairs. Nested left/right objects prevent output-name collisions. Missing keys rejected. JSON sources each 32 KiB / 1,000 records / 200 columns; at most 5,000 output pairs. CSV sources should use the existing CSV Join tool.

data-join-playgroundLOCAL WORKSPACE

Enabling local controls…

Inputs and settings

Processed in this tab without uploading or storing inputs. Each text field is limited to 32 KiB and complete output to 1 MiB; additional format and model limits apply.

Results

Review the settings and run. Editing inputs clears old results.

Processing model and limits

Join typed scalar keys without coercion. SQL-like null keys never match; duplicate keys produce all matching pairs. Nested left/right objects prevent output-name collisions. Missing keys rejected. JSON sources each 32 KiB / 1,000 records / 200 columns; at most 5,000 output pairs. CSV sources should use the existing CSV Join tool.

Data and model checked: PostgreSQL joined tables ↗Source tool controls ↗

How to use this tool

Load the example, confirm field units and processing rules, then run locally. Editing any input clears the old result. Copy or download the complete output explicitly.

When not to use it

Join typed scalar keys without coercion. SQL-like null keys never match; duplicate keys produce all matching pairs. Nested left/right objects prevent output-name collisions. Missing keys rejected. JSON sources each 32 KiB / 1,000 records / 200 columns; at most 5,000 output pairs. CSV sources should use the existing CSV Join tool.