DriveWorks Solo 15: TableSkipRows [send feedback...]

TableSkipRows

Returns a new table where the specified number of rows have been removed from the start of the given table.

Syntax

TableSkipRows([Table] As Table, [Rows to Skip] As Double)

Where:

Table is the table from which to take the rows.

Rows to Skip is the number of rows from the start of the input table that should be omitted.

Examples

RuleMeaning
TableSkipRows(DWLookupCustomers,3)Will return an array of the table Customers with the first 3 rows omitted.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States
Everso LuckyVermontUnited States
Forty SomethingsIllinoisUnited States

Example Outcome

Customers Table

CustomerNameCountry
Cambridge CatsFrance
Dynamo DynamicsUnited States
Eagle SizzlersUnited States
Everso LuckyUnited States
Forty SomethingsUnited States

DriveWorks will return the table above as an array, which will look like:

Table returned as an Array
{"CustomerName","City","Country";"Cambridge Cats","Toulouse","France";"Dynamo Dynamics","Indiana","United States";"Eagle Sizzlers","Maine","United States";"Everso Lucky","Vermont","United States";"Forty Somethings","Illinois","United States"}


Table of Contents