Column Mapping & Data Cleanup
With Osmos, you can clean up and restructure your data using column mapping, QuickFixes, AutoClean, formulas, and single-cell edits.

Overview

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.
Each card in this section represents an output (cleaned) column. You can map one or more input (uploaded) columns to each output column.

Input and Output Columns

After you map 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.

Data Cleanup Panel

To the right of the uploaded and cleaned columns, you can access the Data Cleanup panel. Here 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, AutoClean, and Formulas. You can get to this panel by clicking on any cell in the cleaned column.

Getting Started

Step 1: Start in the left Column Mapping panel. Select the column(s) that contain the data for the first output column listed.
Step 2: If you want to clean up or modify the data in the cleaned column (or resolve errors), click on any cell in the cleaned column to open the Data Cleanup panel.
Step 3: Review the available options in the Data Cleanup panel and select one that best fits your data cleanup needs for this column:
  1. 1.
    QuickFixes - One-click, data-cleanup buttons that allow you to easily clean up your data for the most common scenarios for that data type (i.e. Date, Text, Numeric, etc.).
  2. 2.
    AutoClean - Simple to use AI-powered data cleanup that learns and detects a pattern from examples of the clean data.
  3. 3.
    Formulas - Spreadsheet style formulas used for complex transformations and data clean up.
Note: If you are uploading a file to cleanup (i.e. not using Osmos Pipelines) and you need to make edits to specific cells in the output column after applying QuickFixes, click on any cell in the output column and provide a single-cell-edit.
Step 4: Use the toggles at the top of the page to filter for rows with errors and/or rows flagged for review to confirm all issues with your data have been addressed.
Step 5: Once you have repeated Steps 1 through 4 for each of the required output columns (and any of the optional columns you want to include), you can proceed to the next step.