Returns a new table with only the specified number of rows.
TableTakeRows([Table], [Rows to Take])
Where:
Table is the table to take the rows from.
Rows to Take is the number of rows from the input table that should be present in the result table.
| Rule | Meaning |
|---|---|
| TableTakeRows(DWGroupTableCustomers,3) | Will return an array of the table Customers containing the first 3 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 | Indianapolis | United States |
| Eagle Sizzlers | Columbus | United States |
| Everso Lucky | Burlington | United States |
| Forty Somethings | Chicago | United States |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","City","Country";"Amazon Warriors","Paris","France";"Bolton Burners","Concord","United States";"Boston Bulls","Hanover","Germany"} |