Appends the columns from the given Tables in order, and returns the result.
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.
| Rule | Meaning |
|---|---|
| TableAppendColumns(DWLookupCustomers, DWLookupContacts) | Will return an array of the columns from the table Customers and Contacts. |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| TT Tigers | London | United Kingdom |
| Super Jets | New York | USA |
| Munich Marshalls | Munich | Germany |
Contacts Table
| ContactName | TelNumber |
|---|---|
| Frank Doran | 8756798123 |
| Malcolm Savidge | 11234266772 |
| Anne Begg | 10018728937 |
| Helen Liddell | 34987110229 |
| 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 |
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"} |