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

store JobID

Formula

=JobID()

=Job_ID()

Description

Returns the UUID of the current job.

Examples

Example 1:

=jobid() => "9b9O8223-df3b-4e47-9bc7-b74fe2c08528"

Example 2:

=job_id()=> "9b9O8223-df3b-4e47-9bc7-b74fe2c08528"