Record Sampling


The Record Sampling transform returns the specified number of records out of the full set of records by random selection.

Transform - Record Sampling
Transform - Record Sampling

1. Input

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

2. Add the transform

Select the connector link between two transforms.

Select a connector link
Select a connector link

In the toolbar, choose Insert Other, then Record Sampling.

Adding from the toolbar
Adding from the toolbar

  • To edit/configure the transform, select it and choose Configure in the toolbar.

    Configure the transform
    Configure the transform

    3. Configure

    In the Record Sampling transform configuration dialog:

    Record Sampling transform configuration
    Record Sampling transform configuration

    1. Set Sampling Record Quantity - The number of records in the output.
    2. Optionally, set Random Seed - An arbitrary number no greater than 2,147,483,647, used to used to initialize a pseudorandom number generator. If set to zero, the current time is used to randomly determine which records will be sampled; otherwise, the same records will be sampled given the same input data and sampling record quantity.
    3. Select the columns to be included in the output.

    As with other transforms, these settings can be turned into a parameter to be changed outside of the transform or the data cube (e.g., with a filter on a dashboard) by clicking Define parameters.

    4. Output

    Submit the configuration dialog, and with the transform selected, open the Data Preview window to view the output.

    5. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

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