Database cleansing
ThinkAutomation automatically executes database commands, as well as updating databases either directly or using custom SQL statements.
As part of this, you can use ThinkAutomation to automate your data cleansing processes. Archaic data can be removed, invalid entries reformatted and inaccurate manual entries eliminated.
Use case
You want to ensure that all your telephone numbers have been formatted with the correct country code. So, you perform a database pull to find all customers situated in the UK whose listed numbers do not begin with the correct +44 code, and push a mass change.