CleanDims

01 / Standardize

One vendor, three strings.

One vendor, three strings. An exact-match join drops two of them.

Example

Raw vendorCanonical valueID
AWSAmazon Web ServicesVEN-0033
awsAmazon Web ServicesVEN-0033
Amazon Web ServicesAmazon Web ServicesVEN-0033

Use it when spelling differences make an exact-match join drop values.

The problem.

When there is no shared ID, analysts rebuild lookup tables by hand for every project. The work is slow, error-prone and never reused.

The shared key.

CleanDims builds the missing key from the text columns they do share: places, industries, vendors. Each decision is kept and reused.