Alteryx Select Records

The Alteryx Select Records tool helps us to select a range of rows/records. We can use this Select Records tool for row sampling or return the discontinued range of rows. To demonstrate this Alteryx Select Records Tool, we used this text file.

Alteryx Select Records Tool 1

Drop the Input Data Tool, and select the CustWithoutDate text file from the Connect a File or Database option.

Alteryx Select Records Tool 2

Alteryx Select Records Tool Example

Please go to the Preparation tab, drag the Select Records tool to the canvas, and connect the Input tool. As you can see, the Select Records configuration tab has an option to enter the numeric range. Based on the given range, the Select Records tool will display the output.

Select Records 3

We have given the range like five and hit the run button. As you can see, Alteryx is displaying the fifth record from the Customers file.

Alteryx Select Records Tool 4

Range = -5. The Alteryx Select Records returns all the customers up to 5.

Alteryx Select Records Tool 5

Range = +5. The Select Records tool returns the customers from 5 to the end.

Select Records 6

Range = 6-14. The Select Records display the customers from 6 to 14.

Alteryx Select Records Tool 7

Range = 18. As there are no records, it is displaying no records.

Alteryx Select Records Tool 8

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.