âShow Table of Contents
The Sample In-DB tool limits the In-DB stream to a number or percentage of records. There is an option to base the sampled records on a designated field sort order.
Use the Sample In-DB tool to limit the amount of data records to optimize runtime and throughput.
Drag a Sample In-DB tool from the Tool Palette onto the workflow canvas.
Connect another In-DB tool's output to the input of the Sample In-DB tool.
With the Sample In-DB tool selected, configure the tool using the Properties window on the left.
Use the drop down list to specify the type of sample. Choices are:
Number: Returns the number of records specified.
Percent: Returns the percent of records specified. Selecting this option requires the data to pass thru the tool twice: once to calculate the count of records and then to return the specified percent of records.
Select or type the number or percent of records to include in the sample.
Sample records based on order: When checked, the records will be sorted in-database before the number or percent of records is chosen to produce the results. To configure the order the data should be sorted:
Select the field to sort on from the Name drop down list.
Choose either Ascending or Descending from the Order drop down.
Manipulate the sorting order by using the Up, Down, and Delete buttons on the right.
Â©2017 Alteryx, Inc., all rights reserved. AllocateÂ®, AlteryxÂ®, GuzzlerÂ®, and SolocastÂ® are registered trademarks of Alteryx, Inc.