Data type and specific values

The following generators populate a column with a specific value or a random value of a specific type.

Blank

The Blank generator inserts a null value.

Boolean

Inserts a random boolean value - either true or false.

Constant

Inserts the same value into all of the rows.

In the Value field, provide the value to use.

Image (Binary)

Produces a JPEG image in binary format.

Lorem Ipsum

Populates the column with filler text.

To configure the generator:

1. From the Generate dropdown list, select whether to generate:

   1. Words - In other words, a single phrase

   2. Sentences

   3. Paragraphs

2. From the Distribution dropdown list, select the distribution method for the generated values among the rows.

3. In the Minimum field, provide the minimum number of words, sentences, or paragraphs in each value.

4. In the Mean field, provide the mean number of words, sentences, or paragraphs in each value.

5. In the Standard Deviation field, provide the standard deviation for the number of words, sentences, or paragraphs in each value.

6. In the Maximum field, provide the maximum number of words, sentences, or paragrphs in each value.

Number

Inserts a numeric value.

To configure the generator, from the Distribution dropdown list, select the method to use to distribute the values among the rows.

• Autoincrement - Increments the numeric values in each row.

• Binomial - Generates a binomial distribution of numeric values.

• Exponential - Increments the numeric values exponentially.

• Geometric - Generates a geometric distribution of numeric values.

• Normal - Generates a normal distribution of numeric values.

• Poisson - Generates a poisson distribution of numeric values.

• Series - Generates a series of numeric values.

The distribution type determines the configuration options.

Autoincrement

For an Autoincrement distribution, in the Start at field, provide the number to start with.

Binomial

For a Binomial distribution, to configure the default distribution:

1. In the Minimum field, set the minimum value.

2. In the Success Probability field, set the success probability for the generated values.

3. In the Maximum field, set the maximum value.

4. In the Decimals field, set the number of decimal places to use.

You can also configure variants that are based on a specified condition. For example, you might use the variant when another column contains a specific value. To add a variant:

1. Click Add Variant.

2. In the Condition field, provide the expression to use to identify when to use the variant.

3. Configure the distribution values to use for the variant.

To remove a variant, click Remove.

Exponential

For an exponential distribution, to configure the default increment:

1. In the Minimum field, set the minimum value.

2. In the Rate field, set the rate of increase for the values.

3. In the Maximum field, set the maximum value.

4. In the Decimals field, set the number of decimal places to use.

You can also configure variants that are based on a specified condition. For example, you might increase the value by a different amount when another colulmn contains a specific value. To add a variant:

1. Click Add Variant.

2. In the Condition field, provide the expression to use to identify when to use the variant.

3. Configure the distribution values to use for the variant.

To remove a variant, click Remove.

Geometric

For a geometric distribution, to configure the default distribution:

1. In the Minimum field, set the minimum value.

2. In the Success Probability field, set the success probability for the generated values.

3. In the Maximum field, set the maximum value.

4. In the Decimals field, set the number of decimal places to use.

You can also configure variants that are based on a specified condition. For example, you might use the variant when another column contains a specific value. To add a variant:

1. Click Add Variant.

2. In the Condition field, provide the expression to use to identify when to use the variant.

3. Configure the distribution values to use for the variant.

To remove a variant, click Remove.

Normal

For a normal distribution, to configure the default distribution:

1. In the Minimum field, set the minimum value.

2. In the Mean field, set the mean value.

3. In the Standard Deviation field, set the standard deviation from the mean for the values.

4. In the Maximum field, set the maximum value.

5. In the Decimals field, set the number of decimal places to use.

You can also configure variants that are based on a specified condition. For example, you might use the variant when another column contains a specific value. To add a variant:

1. Click Add Variant.

2. In the Condition field, provide the expression to use to identify when to use the variant.

3. Configure the distribution values to use for the variant.

To remove a variant, click Remove.

Poisson

For a poisson distribution, to configure the default distribution:

1. In the Minimum field, set the minimum value.

2. In the Mean field, set the mean value.

3. In the Maximum field, set the maximum value.

4. In the Decimals field, set the number of decimal places to use.

You can also configure variants that are based on a specified condition. For example, you might use the variant when another column contains a specific value. To add a variant:

1. Click Add Variant.

2. In the Condition field, provide the expression to use to identify when to use the variant.

3. Configure the distribution values to use for the variant.

To remove a variant, click Remove.

Series

For a series of values, to configure the default series:

Start and end columns

You can base the start and end values on other numeric columns in the table.

1. From the Start At dropdown list, select the numeric column to use as the starting value.

2. From the End At dropdown list, select the numeric column to use as the ending value.

Partitioning the series

You can partition the series based on other columns. For example, you can have one series of values for the United States, and another series for France.

To partition the series:

1. From the Partition By dropdown list, select the column to use for the partition.

2. From the Order By dropdown list, select the column to use to sort the rows in each partition.

Decimal places

In the Decimals field, specify the number of decimal places to use for the values.

Curve

From the Curve Type dropdown list, select the type of curve to use.

1. To generate the series along a linear curve, select linear. This is the default

2. To generate the series along an exponential curve:

   1. Select exponential.

   2. In the Rate field, set the rate of increase.

3. To generate the series along a logarithmic curve:

   1. Select logarithmic.

   2. In the Rate field, set the rate of increase.

4. To match the curve to values from another column in the table:

   1. Select from column.

   2. From the column dropdown list, select the column to use.

Volatility

Volatility determines the deviation from the curve.

To use a fixed percentage volatility:

1. From the Volatility dropdown list, select fixed.

2. In the field, provide the percentage of volatility. The higher the percentage, the bumpier the curve.

To base the volatility on another column in the table:

1. From the Volatility dropdown list, select from column.

2. From the column dropdown list, select the column to use.

Configuring variants

You can also configure variants that are based on a specified condition. For example, you might use the variant when another column contains a specific value. To add a variant:

1. Click Add Variant.

2. In the Condition field, provide the expression to use to identify when to use the variant.

3. Configure the distribution values to use for the variant.

To remove a variant, click Remove.

UUID

Generates a random universally unique identifier (UUID).