DriveWorks Pro 15: 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 DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States
Everso LuckyVermontUnited States
Forty SomethingsIllinoisUnited States

Example Outcome

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States
Everso LuckyVermontUnited States
Forty SomethingsIllinoisUnited 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"}


Table of Contents