Returns a new table where the specified number of rows have been removed from the start of the given table.
TableSkipRows([Table], [Rows to Skip])
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.
| Rule | Meaning |
|---|---|
| TableSkipRows(DWGroupTableCustomers,3) | Will return an array of the table Customers with the first 3 rows omitted. |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indianapolis | United States |
| Eagle Sizzlers | Columbus | United States |
| Everso Lucky | Burlington | United States |
| Forty Somethings | Chicago | United States |
Customers Table
| CustomerName | Country |
|---|---|
| Cambridge Cats | France |
| Dynamo Dynamics | United States |
| Eagle Sizzlers | United States |
| Everso Lucky | United States |
| Forty Somethings | United 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","Indianapolis","United States";"Eagle Sizzlers","Columbus","United States";"Everso Lucky","Burlington","United States";"Forty Somethings","Chicago","United States"} |