Combines the rows from the given tables into a single table, re-using columns where they match.
TableCombine(Collection of Tables As Tables)
Where:
Collection of Tables are the tables to combine, where each table name is separated by a comma.
| Rule | Meaning |
|---|---|
| TableCombine(DWGroupTableCustomersAtoC, DWGroupTableCustomersDtoF) | Will return an array comprising of the rows from the CustomersAtoC group table followed by the rows from the group table CustomersDtoF. Duplicate columns will become one column. |
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","Indiana","United States";"Eagle Sizzlers","Maine","United States";"Everso Lucky","Vermont","United States";"Forty Somethings","Illinois","United States"} |