# AI AutoClean

## 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."

<figure><img src="https://lh7-us.googleusercontent.com/docsz/AD_4nXcEgYB0izZf1VTNF-Mei5lH4BqJqK575Upi3UmlRDfNt0LCU7i7qDnNUqQ4wBo6CAd12k-K7HZt13BuWwfBq4xo6exyyvbsd_SbzLKarqqPt-01DUUv-75UamZ82VVR-yM-Vc0tnDoJB7qb-OJM4GQg-O24?key=kO-9412qRoFrvucLdyfXgg" alt=""><figcaption></figcaption></figure>

Here’s an example of a more sophisticated transformation:

<figure><img src="https://lh7-us.googleusercontent.com/docsz/AD_4nXdb1_WVsy5YREYVCycwzOqxGJD-xaP83Y6hBTgUZsX4-_LviV9nDPgaFdQDJOHMKLfjU2yDRg-YA7u1mzVS3lfvRG6eYm2yumme5UKxmeqhZahgEVMpOphUgCZPqIrqZ-7syk2f8gZrFkzCIndmBEi_05tn?key=fOtxg1l0FjD3VR7apXm1dg" alt=""><figcaption></figcaption></figure>

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).

## 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.

<figure><img src="/files/d8F1DSOVmIcc43Ohxg0a" alt=""><figcaption></figcaption></figure>

## 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.&#x20;

Step 2: Select Transform on the left-hand side column mapping field.  In this scenario, it will be the destination Employee\_Type field.&#x20;

<figure><img src="/files/raxcOU7UXYjmCHUVAtbR" alt=""><figcaption></figcaption></figure>

Step 3: Select the Auto Clean QuickFix.  Enter how you would like to clean the field. &#x20;

<figure><img src="/files/vQcWgJB30FAx520qcg31" alt=""><figcaption></figcaption></figure>

###


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.osmos.io/data-transformations/ai-autoclean.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.