Skip to main content

Random % Sample Tool

Use Random % Sample to return an expected number of rows that result in a random sample of the incoming data stream.


This tool has a One Tool Example. Visit Access Sample Workflows to learn how to access this and many other examples directly in Designer Cloud.

Configure the Tool

  1. Specify the number of rows to return.

    • Random N Rows: Select a Number of Rows to specify the number of rows to output.

    • Random N% of Rows: Select a Percent of Rows to specify the percentage of incoming rows to output.

  2. Check Output Same Set of Random Rows on Each Run to ensure the same set of random results is returned each time you run the workflow. Select a Random Seed value to set the starting point to generate random numbers.

  3. Optionally, check the Columns to Group By.