As well as identifying data quality issues, Spotless can clean dirty data and replacing invalid fields with corrected data.
Supported rules are:
- Fixing dates and times to a specific format
- Correcting numbers to a given number of decimal places
- Setting unique foreign key references that have been truncated or corrupted
- Adding missing data using our machine learning lookalike model
- Updating common spelling mistakes with a lookup rule