Getting Started

Overview

Data Transformation begins with column mapping. Our AutoMap AI significantly reduce the need for manual column mapping that is required during data ingestion. Our AutoMap AI takes that task and automatically maps your columns quickly and more accurately. It will immediately map things like “MSRP” to “Price,” “Vehicle Identification Number” to “VIN,” or “patient_ID” to “person_ID” at the touch of a button.

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 trigger the Data Cleanup panel (on the left side panel).

The left side panel toggles between column mapping and data clean up.

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. 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. SmartFill - Simple to use AI-powered data cleanup that learns and detects a pattern from examples of the clean data.

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 tabs 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.