Other Formulas
Last updated
Last updated
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.
=skip()
Skips the given row.
Argument
Required (Y/N)
Description
N/A
N/A
N/A
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.
=uuid([input1])
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.
Argument
Required (Y/N)
Description
Input1
N
An optional input to generate a uuid
based on hash
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
=JobID()
=Job_ID()
Returns the UUID of the current job.
Example 1:
=jobid()
=>"9b9O8223-df3b-4e47-9bc7-b74fe2c08528"
Example 2:
=job_id()
=>"9b9O8223-df3b-4e47-9bc7-b74fe2c08528"