Returns a new table with only the specified rows.
TableGetRows([Table], [First Row], [Rows to Take])
Where:
Table is the Table from which to get the rows.
First Row is the number of the first row to take.
Rows to Take is the number of rows to retrieve.
| Rule | Meaning |
|---|---|
| TableGetRows(DWGroupTableCustomers, 2, 5) | Will return an array from the Customers group table, starting at row 2 and containing 5 rows. |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indiana | United States |
| Eagle Sizzlers | Maine | United States |
| Everso Lucky | Vermont | United States |
| Forty Somethings | Illinois | United States |
| CustomerName | City | Country |
|---|---|---|
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indiana | United States |
| Eagle Sizzlers | Maine | United States |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","City","Country";"Bolton Burners","Concord","United States";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France";"Dynamo Dynamics","Indiana","United States";"Eagle Sizzlers","Maine","United States"} |