Osmos Uploader

Osmos Pipelines

Column Mapping & Data Cleanup

Mapping & Transforming Data (Old UI)

Source Connectors

Destination Connectors

Security

Support

... Using Formulas

- 1.How are Formulas Used in Osmos?
- 2.Supported Formulas
- 3.Common Use Cases
- 4.Getting Started
- 5.Color Coding
- 6.Editing or Deleting Training Examples

How are Formulas Used in Osmos?

Formulas are used to quickly transform and map your source data to the columns in the output table. We have several predefined formulas (such as CONCAT, DATE, ADD, IF, etc.) that can be used together to complete complex transformations.

Supported Formulas

We have several formulas that fall into one of the following four categories noted below. For more information about our formulas, navigate to one of the pages below.

- 1.
- 2.
- 3.
- 4.

Common Use Cases

Commonly used formulas include CONCAT and DATE.

- 1.The
**CONCAT**formula outputs concatenated input values. This is useful for combining data from multiple source columns, or adding a constant value to every source record for a specific column. - 2.The
**DATE**formula converts the input into a date. This is useful for extracting dates from a string, and/or converting the format of the date.

Getting Started

For the example below, we are using the **DATE **formula.

For this example, we are using the** Date source column as the input for the formula**. We have left the second argument (input_format) blank (see the Date Formula for more info) and have specified the output format using our supported date-time formats.

In the example below (click to expand) you can see that we have mapped the Date source column (on the left) to the Date destination column (on the right), and changed the date format based output format specified in the formula.

Color Coding

Cells that contain **formulas, ****column mapping** or** ****training examples**** **have **black borders**. If you want to adjust the output for that column, click on these cells to delete or edit them.

Cells with Red Borders

Cells that have **errors** will have a **red border**. The cell that contains the formula can have an error, and other cells within that column can have errors. In either case, you must edit the formula to resolve any errors within a column containing a formula.

Editing and Deleting Formulas

If you want to **edit** a formula, **click on the cell** that contains the formula, **edit the formula**, then **press enter** to submit the revised formula.

If you want **delete** a specific formula, **click on the cell** that contains the formula, then click on the **delete button** to the right of that cell.

â€‹

Mapping & Transforming Data (Old UI) - Previous

... Using Column Mapping

Next - Mapping & Transforming Data (Old UI)

... Using Training Examples

Last modified 3mo ago