Home Search

DriveWorks Pro 21
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 DynamicsIndianapolisUnited States
Eagle SizzlersColumbusUnited States
Everso LuckyBurlingtonUnited States
Forty SomethingsChicagoUnited States

Example Outcome

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianapolisUnited States
Eagle SizzlersColumbusUnited States
Everso LuckyBurlingtonUnited States
Forty SomethingsChicagoUnited 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","Indianapolis","United States";"Eagle Sizzlers","Columbus","United States";"Everso Lucky","Burlington","United States";"Forty Somethings","Chicago","United States"}