Value

Create individual values.

Boolean

Boolean

Select a constant Boolean value.

Column name

Column name

Specify the name of a single column in the data.

Date

Date

Specify a fixed date.

Number

Number

Specify a fixed number.

Text

Text

Specify a fixed text. The value should not be quoted: any single or double quotes provided will be included in the text.

Row number

Row number

Produce the row number of this record. Row numbers start at 1.

Uniform random number

Uniform random number

Generate a random value from a uniform distribution.

Normal random number

Normal random number

Generate a random value from a normal distribution.

Exponential random number

Exponential random number

Generate a random value from an exponential distribution.