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 lengths of the generated values among the rows.

3. Configure the selected distribution.

The available distributions are:

• Uniform - Generates a uniform distribution of content length.

• Binomial - Generates a binomial distribution of content length.

• Exponential - Increments the content length exponentially.

• Geometric - Generates a geometric distribution of content length.

• Normal - Generates a normal distribution of content length.

• Poisson - Generates a poisson distribution of content length.

• Series - Generates a series of content lengths.

Uniform

For a Uniform distribution, to configure the distribution:

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

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

Binomial

For a Binomial distribution, to configure the distribution:

1. In the Trials field, set the number of tests to run.

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

Exponential

For an exponential distribution, to configure the increment:

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

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

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

Geometric

For a geometric distribution, to configure the distribution:

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

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

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

Normal

For a normal distribution, to configure the distribution:

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

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

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

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

Poisson

For a Poisson distribution, to configure the distribution:

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

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

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

Series

For a series of lengths, to configure the series:

Start and end columns

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

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

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

Partitioning the series

You can partition the series based on other columns. For example, you can have one series of lengths 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.

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.

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.

• Uniform - Generates a uniform distribution of numeric values.

• 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.

Uniform

For a Uniform distribution, to configure the default distribution:

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

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

3. 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.

Binomial

For a Binomial distribution, to configure the default distribution:

1. In the Trials field, set the number of tests to run.

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

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 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.

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).