Join Footprint
Predict row multiplication before joining two tables on a key.
Prepare your sheet
Use one row per join key observation. Enter Left rows, Right rows. Check that every row belongs to the same review scope.
Decision rule
Enter counts on each side once per distinct key. This models an inner equijoin without filtering or null keys.
Worked result
The fictional example contains 3 input rows. Its result is 7 inner-join rows.
| Key | Left | Right | Output | Relationship |
|---|---|---|---|---|
| K1 | 2 | 3 | 6 | Many-to-many |
| K2 | 1 | 1 | 1 | Matched |
| K3 | 1 | 0 | 0 | Left only |
Run it on your own inputs
- Open the tool and choose Start empty or edit the example.
- Enter the inputs, resolve validation messages and review the decision sheet.
- Download the text report or print the summary for the responsible person.
Source and support
Predict row multiplication before joining two tables on a key. The demonstration requires actual execution before work can be marked complete. Benchcraft designed this tool’s inputs, decision rule and example for this office task. Reviewed source · Nate Herk | AI Automation.
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.