# 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="/files/LzDSoPRC7oaJkW3pjvDb" 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"`


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.osmos.io/data-transformations/formulas/other-formulas.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
