Overview

Overview

Column mapping leverages a technique Osmos calls AutoMap. AutoMap automatically maps headers and columns from your uploaded data to your destination schema. Osmos leverages Generative AI to maps your columns quickly and more accurately. When AutoMap is triggered, it notes it in the top right hand corner.

Column Mapping Panel

On the left, you will see the column mapping panel. This is where you start, and where you map the relationship between the input (uploaded) and output (cleaned) columns.

Each card in this section represents an output column for your Uploader Destination. You can map one or more uploaded columns to each cleaned (Our Field) column.

Input and Output Columns

After you map an input (uploaded) column to an output (cleaned aka Our Field) column, you will see the data that corresponds to the selected columns to the right of the mapping section.

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

Column Mapping Filters

To streamline the mapping process, you can filter fields by a variety of 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.

Show Filter

Type Filter

Field Filter

Data Cleanup Panel

In the Data Cleanup panel, you can use tools that help you quickly cleanup the data being sent to the output column you are working on. These tools include QuickFixes, SmartFill, and Formulas, and single-cell edits.

The left side panel toggles between column mapping and data clean up. You can access this panel on the left by clicking on any cell in the Our Field column.