Pattern: Filter Random Sample of Data Table Rows, Variably up to 50 Rows

Thomas_937381 Posts: 196
edited July 2020 in Show and Tell

If you can't use Tables: Apply formulas to columns or CSV: Apply formulas to columns to do fully automated, logical validation of a dataset, and/or if people need to validate a random sample of data, you can use the attached pattern to filter for a variable percentage of total rows in the dataset, with a max number of filtered rows of 50.

Check the filter-for-samples table in the Filter row index by random numbers step. Note that this workflow leverages loops to determine which rows to filter, and may take some time if you are filtering a high number of rows.

The Sample Table used in this process has 100 rows of data, and looks like this.