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
@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.
@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.