CleanDims

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

SourceText valueCanonical IDJoin level
Store salesNYPLC-0036state
County populationNew York CountyPLC-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.