# Column Mapping & Data Cleanup Panel

## Overview <a href="#destination-table" id="destination-table"></a>

With Osmos, you can clean up and restructure your data using [AutoMap AI,](#automap-ai) [Lookups,](/data-transformations/lookups.md) [column mapping](#column-mapping-panel), [QuickFixes](/data-transformations/quickfixes.md), [SmartFill](/data-transformations/smartfill.md), [formulas](/data-transformations/formulas.md), and single-cell edits.&#x20;

### AutoMap

Data Transformation begins with column mapping.  Our AutoMap makes [column mapping](https://www.osmos.io/data-transformation) –typically a manual process–faster (and more accurate) than before by automatically suggesting mappings. [ AutoMap ](https://www.osmos.io/blog/osmos-announces-enhanced-automap-ai)uses generative AI to significantly reduce the need for manual column mapping that is required during data ingestion.  AutoMap takes that task and automatically maps your columns quickly and more accurately. Immediately map things like “MSRP” to “Price” and “Energy” to “Calories”.  No additional setup is required.

<figure><img src="/files/GOdgBqWx8vv8K5EwSLYy" alt="" width="375"><figcaption></figcaption></figure>

On the left, you will see the column mapping panel. This is where you map the relationship between the input and output columns. &#x20;

Note: You can map one or more input (uploaded) columns to each output column.  Leverage the + column icon to add additional input fields.

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

### Input and Output Columns&#x20;

After an input column (uploaded column) to an output column (cleaned column), you will see the data that corresponds to the selected columns to the right of the mapping section.&#x20;

When you select a different output column in the mapping section, the section to the right will update to display the corresponding data for those columns.

<figure><img src="/files/8v9iyYTq8jIra2xDQY7g" alt=""><figcaption></figcaption></figure>

### Column Mapping Filters&#x20;

To streamline the mapping process, you can filter fields by several factors.  These include mapped vs unmapped, required vs optional, field errors, warnings, skipped rows, fields with formulas, SmartFill, or QuickFixes. In addition, you can filter by field type, specific fields themselves, or simply search for fields.

{% tabs %}
{% tab title="Show Filter" %}

<div align="left"><figure><img src="/files/t2zHN3sVWdVBO8l1v1qv" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Type Filter" %}

<div align="left"><figure><img src="/files/UG8xKwuaDk8mZMzgDFdY" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Fields Filter" %}

<div align="left"><figure><img src="/files/61ieVHguXzSnjn18C1tq" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}
{% endtabs %}

### Fill with Constant Value

To set a constant value for the destination column, leave the Your Column (source) column blank and select Fill with Constant Value.   This will take you into the [formula window](/data-transformations/formulas.md) to enter your value.&#x20;

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

### Adding File Name Mapping

The originating file name field is available to add to an Our Field (destination) column.  This field is available at the end of the Your Columns (source) column list.&#x20;

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

<figure><img src="/files/8D3mraE7XRO4s1N0R25j" alt=""><figcaption></figcaption></figure>

### Data Cleanup Panel

In the Data Cleanup panel, you can use tools that help you quickly clean up the data being sent to the output column you are working on. These tools include [AI Value Mapping](/data-transformations/ai-value-mapping.md), [Lookups,](/data-transformations/lookups.md) [QuickFixes](/data-transformations/quickfixes.md), [SmartFill](/data-transformations/smartfill.md), [formulas](/data-transformations/formulas.md), and single-cell edits.

The left side panel toggles between column mapping and data cleanup. You can access this panel on the left by clicking on any cell in the destination column.

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

## &#x20;<a href="#destination-table" id="destination-table"></a>


---

# 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/column-mapping-and-data-cleanup-panel.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.