01 / Standardize
One vendor, three strings.
One vendor, three strings. An exact-match join drops two of them.
Example
| Raw vendor | Canonical value | ID |
|---|---|---|
| AWS | Amazon Web Services | VEN-0033 |
| aws | Amazon Web Services | VEN-0033 |
| Amazon Web Services | Amazon Web Services | VEN-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.