Select Record Tool

Question

Hi!

I'm wondering if anyone can help me to understand the select record tool

I already read https://help.alteryx.com/designer-cloud/select-records-tool

it still does not make sense to me.

is there any simpler way to understand this?

Let's say I have a range of

-50

100

150-160

200+

and I have a dataset of 1000. Does anyone know how to count the record? Is there any formula for this?

-50 means return rows 1-50 [50 records]

100 means return row 100 [1 record]

150-160 means return rows 150,151,152,153,154,155,156,157,158,159,160 [11 records]

200+ means return rows 200-1000 [800 records] <idk if we need to calculate the "200"

total 852 records.

For the + number, do we need to include the x number in a calculation?

am I correct?  plz, help me. thank you

allwynthomas24 · Answer

@rively90,
Lets get this Straight for you buddy.

Select Record Tool is used when you want to directly return any record or range of records from your data set without any condition. You just enter the Row Number and press Run, you will get the specified row. This tool depends upon the Record Column (extreme left) which is generated automatically starting from Record No. 1 by the Alteryx Software itself. Hence the output from this tool will again have output with Record Column starting from Record No. 1. So just to remove the confusion, use a Record ID Tool which will assign a unique identifier to each record and then use the Select Record Tool.

Terminology:

Here "+ (plus)" equivalents to ">= (greater than, equal to)"
Eg: 200+ means return records starting at the 200th Row till the last row of your data set. Total=801 records

Here "- (minus)" equivalents to "<= (less than, equal to)"

Eg: -50 means return records starting at the 1st row upto and including the 50th row. Total=50 records

Next we use hyphen (-) to define range of rows.

Eg: 150-160 means return records starting at 150th row upto and including the 160th row. Total=11 records
Ranges are always inclusive of start number and end number. Its similar to BETWEEN keyword in SQL.

A single digit would basically return the record available at the particular row number.

Eg: 100 means return record available at that 100th row. Total=1 record

801+50+11+1 = 863 Total Records.

This is the simplest way I could write it out for you.

Hope this helps.

JarekSkudrzyk · Answer

@rively90 
here are my asnwers to your questions:

Does anyone know how to count the record? Is there any formula for this? - records are counted starting from 1 (not 0 based); you have the record number on the left of the dataset preview:

The total no of records is displayed on the top of data preview section:

-50 means return rows 1-50 [50 records] yes

100 means return row 100 [1 record] yes

150-160 means return rows 150,151,152,153,154,155,156,157,158,159,160 [11 records] yes

200+ means return rows 200-1000 [800 records] <idk if we need to calculate the "200" actually 801 records

total 852 records. actually 863 records

Please find a simple workflow to illustrate this.
Let me know if this answers your questions.

New Workflow1.yxmd