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.

Data Cleanup

Users can cleanup data through AutoClean and single-cell edits.

AutoClean is a capability which allows end users clean data with one click. Your Osmos Uploader comes with prebuilt AutoClean capability for certain scenarios detailed below, but also empowers developers with the ability to transform data on the fly by creating their own AutoClean functions.

Last updated