AI AutoClean
Last updated
Was this helpful?
Last updated
Was this helpful?
What is AI AutoClean?
Getting Started
With AI Autoclean, users can provide simple instructions using everyday language to tell Osmos how to transform the data.
For example, this can be as simple as, “Convert to US phone number format in (XXX) XXX-XXXX format” or "Format as a US phone number with area code in parenthesis."
Here’s an example of a more sophisticated transformation:
AutoClean can be used throughout Osmos in both Uploaders and Pipelines. It is most commonly used with an Uploader and is located under the QuickFix menu. AutoClean democratizes the transformation process, making it viable to transition the work from sophisticated data experts to everyday users!
Customer ABC is ingesting employee data. The employee data includes employee type, which needs to empower end-users to tell Osmos how to clean the data using natural language. In this scenario, see how to use AutoClean to write and apply AutoClean Quickflix.
Uploader Advanced Mode
Step 1: Go to your newly created Uploader and upload your data. Once the AutoMapping is complete, select the field you wish to initiate the Auto Clean. In our scenario it is Employee_Type.
Step 2: Select Transform on the left-hand side column mapping field. In this scenario, it will be the destination Employee_Type field.
Step 3: Select the Auto Clean QuickFix. Enter how you would like to clean the field.
AI AutoClean is available for Advanced Mode Uploader and Pipelines, the user experience is the same. Note, that AutoClean is most commonly used with Uploaders. .
