03 / Join
Join any datasets, even without common keys.
Sales and census population. Suppliers and company registries. One department’s figures and another’s. They rarely share an ID.
Example
| Source | Text value | Canonical ID | Join level |
|---|---|---|---|
| Store sales | NY | PLC-0036 | state |
| County population | New York County | PLC-0036 (roll-up) | state |
Use it when datasets must be combined but share no ID or key.
Build the missing key.
CleanDims builds the missing key from the text columns they do share: places, industries, vendors.
Download or sync the outputs.
Join any sources on the ID. One canonical layer with hierarchy levels, reused by every later join.