Replaces a row in the given table.
TableReplaceRow([Table], [Row Index], [Replacement Row])
Where:
Table is the Table in which to replace the row.
Row Index is the index of the row to replace.
Replacement Row is either a single row array or multiple row array that will replace the row at the specified index. The array must include a header row.
| Rule | Meaning |
|---|---|
| TableReplaceRow(DWGroupTableCustomers, 2, {"","","";"Bolton Burners","Waltham","USA"}) | Will replace the second row in the Customers table with the values Bolton Burners, Waltham and USA |
| TableReplaceRow(DWGroupTableCustomers, 2, TableRow("Bolton Burners","Waltham","USA")) | Does exactly as above but uses the TableRow function to construct the Replacement array. |
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 |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Waltham | USA |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
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","Waltham","USA";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France"} |