Column Mapping & Data Cleanup Panel

Overview

With Osmos, you can clean up and restructure your data using AutoMap, column mapping, QuickFixes, SmartFill, formulas, and single-cell edits.

AutoMap

Column mapping leverages a technique Osmos calls AutoMap. AutoMap automatically maps headers and columns from your source 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 and output columns.

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

Input and Output Columns

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.

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.

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

Fields Filter

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 to enter your value.

Adding File Name Mapping

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

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.

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 destination column.