DriveWorks Pro 22

TableJoin

TableJoin

Performs a join of the specified Tables based on matching values in columns in each of the two Tables.

Syntax

TableJoin([Left Table],[Left Match Column],[Right Table],[Right Match Column],[Join Type],[Data Rows Only],[Include Headers])

Where:

Left Table is the Table to join on the left.

Left Match Column is the number of the column which contains values that will be matched against values in the right Table.

Right Table is the Table to join on the right.

Right Match Column is the number of the column which contains values that will be matched against values in the left Table.

Join Type (optional) is the type of join to perform (either "Inner" or "Outer"), if not specified, by default it will perform an inner join:

• Inner - returns rows from both Tables where there is a match between the columns in both Tables
• Outer - returns all rows from the left Table and from the right Table

Data Rows Only (optional) is TRUE to only match against values in the data rows of the Table (not the header row). FALSE to match against values in all rows of the Table. By default this is FALSE.

Include Headers (optional) is TRUE to include the header row as the first row in the resulting Table. The header row will be the combination of the headers from both tables. FALSE to not include an additional header row. By default this is FALSE.

Examples

Example Data

CustomersAtoC Table

Currency Table

Example Outcome

DriveWorks will return the Table above as an Array. This will look like: