The seq( function returns sequential numbers (1, 2, 3, etc.).
When it is used with the formulafill, find or select statements, the seq( function returns a sequential number for each applicable record (the first selected record is 1, the second is 2, etc.). A record is applicable if the formula is applied to it, for example, selected records for formulafill, or selectwithin, and all records for select.
When it is used with filter operations (arrayfilter, characterfilter, etc.), the seq( function returns a sequential number for each element in the array being processed (the first array element is 1, the second is 2, the third is 3, etc.).
When it is used at any other time, the seq( function returns the number 1.
This procedure selects the first 10 records in the database:
The procedure below will select every 5th record in the database.
select (seq() mod 5)=0
By changing the 0 in this formula to 1, 2, 3, or 4 you can select different sets of data, but still 20% of the database each time.
|10.0||No Change||Carried over from Panorama 6.0|