Appends the rows from the given tables in order, and returns the result.
TableAppendRows(First Table As Table, Second Table As Table, Third Table As Table)
Where:
First Table is the first set of rows for the new table.
Second Table is the second set of rows for the new table.
Third Table (Optional) is the third set of rows for the new table.
| Rule | Meaning |
|---|---|
| TableAppendRows(DWGroupTableCustomersAtoC, DWGroupTableCustomersDtoF) | Will return an array of the rows from the Group Table Customers and the simple table Contacts. |
CustomersAtoC Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
CustomersDtoF Table
| CustomerName | City | Country |
|---|---|---|
| Dynamo Dynamics | Indianapolis | United States |
| Eagle Sizzlers | Columbus | United States |
| Everso Lucky | Burlington | United States |
| Forty Somethings | Chicago | United States |
| 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 |
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";"Cambridge Cats","Toulouse","France";"Dynamo Dynamics","Indianapolis","United States";"Eagle Sizzlers","Columbus","United States";"Everso Lucky","Burlington","United States";"Forty Somethings","Chicago","United States"} |