Appends the columns from the given tables in order, and returns the result.
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.
| 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 |
|---|---|---|---|---|
| France | Frank Doran | 8756798123 | Frank Doran | 8756798123 |
| United Kingdom | Malcolm Savidge | 11234266772 | Malcolm Savidge | 11234266772 |
| USA | Anne Begg | 10018728937 | Anne Begg | 10018728937 |
| Germany | Helen Liddell | 34987110229 | 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";"Munich Marshalls","Munich","Germany","Helen Liddell","34987110229"} |