Record Sampling

Contents[Hide]

The Record Sampling transform reads in all of the data from the previous transform and generates a set of random indexes according to the number input. Then output the records according to those indexes.

Transform - Record Sampling
Transform - Record Sampling

1. Input

The Record Sampling transform requires 1 input transform that has at least 1 column.

The input could be a SQL Select transform, or the result of another transform. For example, the input data is:

Input Data
Input Data

2. Add the Transform

Steps to add the transform:

  1. Select the connector link.

    Adding the Record Sampling transform - Step 1
    Adding the Record Sampling transform - Step 1

  2. Select the transform from the menu.

    Adding the Record Sampling transform - Step 2
    Adding the Record Sampling transform - Step 2

  3. To Edit/Configue the transform, select the newly added transform, and click the Configure menu.

    Adding the Record Sampling transform - Step 3
    Adding the Record Sampling transform - Step 3

3. Configure

Steps to configure the Record Sampling transform:

Record Sampling transform configuration
Record Sampling transform configuration

  1. Sampling Record Quantity - the number of records in the output.
  2. Random Seed - the number used to used to initialize a pseudorandom number generator.
    • Value is from 0 to 2,147,483,647.
    • If the value is 0, the random number generator uses the time and your random indexes will always be different.
  3. Select the columns to be included in the output.

4. Output

The figure below illustrates the output from the Record Sampling transform.

Record Sampling - sample output
Record Sampling - sample output

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri