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.
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 |
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"
Last updated