AI AutoClean

This feature is currently in Beta.

Contents

1. What is AI AutoClean?

2. Getting Started

What is AI AutoClean?

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!

Getting Started

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. See the scenario below.

Scenario

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.

Features

• Uploader Advanced Mode

Performing AutoClean

Scenario 1: 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.