# 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]

{% hint style="info" %}
Skipping a row means the row will not be included in the output.
{% endhint %}

Here is the Skip Feature in action.

<figure><img src="https://353417064-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MYrsDW6vGBTygB1qqSE%2Fuploads%2FeZMzkZbm1g2geoy0gUN2%2FOsmos%20Skip%20in%20Action.gif?alt=media&#x26;token=b49445e1-9b5c-437f-8e85-cf38ba5f81dc" alt=""><figcaption><p>Osmos Skip Feature</p></figcaption></figure>

## 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.&#x20;

#### Examples

> **Example 1:**
>
> `=jobid()` => `"9b9O8223-df3b-4e47-9bc7-b74fe2c08528"`
>
> **Example 2:**
>
> `=job_id()`=> `"9b9O8223-df3b-4e47-9bc7-b74fe2c08528"`
