Home Search

DriveWorks Pro 21
TableAppendColumns

Send Feedback

TableAppendColumns

Appends the columns from the given Tables in order, and returns the result.

Syntax

TableAppendColumns([First Table],[Second Table],[Third Table])

Where:

First Table is the first set of columns for the new table.

Second Table is the second set of columns for the new table.

Third Table (Optional) is the third set of columns for the new table.

Examples

RuleMeaning
TableAppendColumns(DWLookupCustomers, DWLookupContacts)Will return an array of the columns from the table Customers and Contacts.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
TT TigersLondonUnited Kingdom
Super JetsNew YorkUSA
Munich MarshallsMunichGermany

Contacts Table

ContactNameTelNumber
Frank Doran8756798123
Malcolm Savidge11234266772
Anne Begg10018728937
Helen Liddell34987110229

Example Outcome

CustomerNameCityCountryContactNameTelNumber
Amazon WarriorsParisFranceFrank Doran8756798123
TT TigersLondonUnited KingdomMalcolm Savidge11234266772
Super JetsNew YorkUSAAnne Begg10018728937
Munich MarshallsMunichGermanyHelen Liddell34987110229

DriveWorks will return the table above as an Array, which will look like:

Table returned as an Array
{"CustomerName","City","Country","ContactName","TelNumber";"Amazon Warriors","Paris","France","Frank Doran","8756798123";"TT Tigers","London","United Kingdom","Malcolm Savidge","11234266772";"Super Jets","New York","USA","Anne Begg","10018728937";"Manich Marshalls","Munich","Germany","Helen Liddell","34987110229"}