Column Mapping & Data Cleanup Panel
Last updated
Last updated
With Osmos, you can clean up and restructure your data using AutoMap AI, Lookups, column mapping, QuickFixes, SmartFill, formulas, and single-cell edits.
Data Transformation begins with column mapping. Our AutoMap makes column mapping –typically a manual process–faster (and more accurate) than before by automatically suggesting mappings. AutoMap 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.
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.
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.
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.
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.
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.
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.
