CleanDims

02 / Connect

Find the columns that describe the same dimension.

Find the columns that describe the same dimension across datasets.

Example

DimensionSource columnCanonical dimension
PlaceSTORE_SALES.REGIONPlace
Placecounty_population.county_namePlace
IndustryACCOUNTS.INDUSTRYIndustry
Industrycompanies.industry_classIndustry

Use it when systems name columns differently and you need a shared view of what joins with what.

Schemas and distinct values.

CleanDims reads the schemas and distinct values of your sources, never whole rows.

You approve each mapping.

Columns are grouped into dimensions using five signals and one score. A mapping takes effect only when someone approves it. A text join needs the values inside a column to agree, not just the fields.