Home Search

DriveWorks Solo 21
TableAppendColumns

Send Feedback

TableAppendColumns

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

Syntax

TableAppendColumns(First Table As Table, Second Table As Table, Third Table As 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
FranceFrank Doran8756798123Frank Doran8756798123
United KingdomMalcolm Savidge11234266772Malcolm Savidge11234266772
USAAnne Begg10018728937Anne Begg10018728937
GermanyHelen Liddell34987110229Helen 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";"Munich Marshalls","Munich","Germany","Helen Liddell","34987110229"}