Enter counts on each side once per distinct key. This models an inner equijoin without filtering or null keys.
Data integrity / Analytics engineer
Join Footprint
Predict row multiplication before joining two tables on a key.
01 / Inputs
Working sheet
Edit any cell to recalculate. Use anonymous references. Data stays in this browser tab and clears when you reload.
| Join key | Left rows | Right rows | Row |
|---|
02 / Review
Decision sheet
| Key | Left | Right | Output | Relationship |
|---|---|---|---|---|
| K1 | 2 | 3 | 6 | Many-to-many |
| K2 | 1 | 1 | 1 | Matched |
| K3 | 1 | 0 | 0 | Left only |
Request a custom workflow
€149 one-time pilot after written scope agreement. JB Codex adapts one repeated job with a worked example and owner review.
The free tool runs independently on your device.