Column Mapping & Data Cleanup Panel

Overview

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

AutoMap AI

Data Transformation begins with column mapping. Our AutoMap AI makes column mapping –typically a manual process–faster (and more accurate) than before by automatically suggesting mappings. AutoMap AI uses generative AI to significantly reduce the need for manual column mapping that is required during data ingestion. AutoMap AI 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.

On the left, you will see the column mapping panel. This is 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 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.

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 an 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 clean up the data being sent to the output column you are working on. These tools include AI Value Mapping, Lookups, QuickFixes, SmartFill, formulas, 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.

Last updated