Home Search

DriveWorks Pro 22
TableCombine

Send Feedback

TableCombine

Combines the rows from the given tables into a single table, re-using columns where they match.

Syntax

TableCombine(Collection of Tables As Tables)

Where:

Collection of Tables are the tables to combine, where each table name is separated by a comma.

Examples

RuleMeaning
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.

Example Data

CustomersAtoC Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance

CustomersDtoF Table

CustomerNameCityCountry
Dynamo DynamicsIndianapolisUnited States
Eagle SizzlersColumbusUnited States
Everso LuckyBurlingtonUnited States
Forty SomethingsChicagoUnited States

Example Outcome

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianapolisUnited States
Eagle SizzlersColumbusUnited States
Everso LuckyBurlingtonUnited States
Forty SomethingsChicagoUnited 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"}