Reverses the order of the rows in the given table.
TableReverse([Table])
Where:
Table is the Table to reverse the row order of.
Rule | Meaning |
---|---|
TableReverse(DWGroupTableCustomers) | Will reverse the existing order of the rows in the Customers table. |
Customers Table
CustomerName | City | Country |
---|---|---|
Amazon Warriors | Paris | France |
Bolton Burners | Concord | United States |
Boston Bulls | Hanover | Germany |
Cambridge Cats | Toulouse | France |
Customers Table
CustomerName | City | Country |
---|---|---|
Cambridge Cats | Toulouse | France |
Boston Bulls | Hanover | Germany |
Bolton Burners | Waltham | USA |
Amazon Warriors | Paris | France |
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";"Boston Bulls","Hanover","Germany";"Bolton Burners","Concord","United States";"Amazon Warriors","Paris","France"} |