DriveWorks Pro 15: TableAppendRows [send feedback...]

TableAppendRows

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

Syntax

TableAppendRows(First Table As Table, Second Table As Table, Third Table As Table)

Where:

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

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

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

Examples

RuleMeaning
TableAppendRows(DWGroupTableCustomersAtoC, DWGroupTableCustomersDtoF)Will return an array of the rows from the Group Table Customers and the simple table Contacts.

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