Links

Other Formulas

Skip Records

When you enter a Skip formula, you can filter records by Skip as well as identify the source column for each Skip you created in the mapping section.

Formula

=skip()

Description

Skips the given row.

Arguments

Argument
Required (Y/N)
Description
N/A
N/A
N/A

Examples

Example 1:
= if(equals($"Cost", 0), skip(), $"Cost") = [skips row OR lists cost]
Skipping a row means the row will not be included in the output.
Here is the Skip Feature in action.
Osmos Skip Feature

Generate UUID

Formula

=uuid([input1])

Description

Creates a unique identifier. With no arguments UUID() will generate a randomly generated value in a uuid format. If additional information is included as an argument, the uuid created will correspond to the input data based on a hashing algorithm.

Arguments

Argument
Required (Y/N)
Description
Input1
N
An optional input to generate a uuid based on hash

Examples

Example 1:
=uuid() = ed7ba470-8e54-465e-825c-99712043e01c
Example 2:
=uuid($"column1") = a0000000-b000-c000-d000-e00000000000
Example 3:
=uuid(concat($"column1",$"column2")) = 1a000000-2b00-3c00-4d00-5e0000000000