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.
Skips the given row.
Example 1:
= if(equals($"Cost", 0), skip(), $"Cost") = [skips row OR lists cost]
Here is the Skip Feature in action.
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.
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
Returns the UUID of the current job.
Example 1:
=jobid() => "9b9O8223-df3b-4e47-9bc7-b74fe2c08528"
Example 2:
=job_id()=> "9b9O8223-df3b-4e47-9bc7-b74fe2c08528"
