Developing Apama Applications > Dashboard Function Reference > Tabular Functions > Join
Join
Returns the result of performing an inner join of two specified tables on specified columns. The result contains all columns from Left Table followed by all columns from Right Table, and contains all rows for which the value in Left Column exactly matches the value in Right Column. Left Column Name and Right Column Name can each specify a semicolon-separated list of n column names, in which case a match occurs if the ith value in Left Column Name exactly matches the ith value in Right Column Name, for all i between 1 and n, inclusive.
Arguments
The function has the following arguments:
*Left Table: Table on which the join is to be performed.
*Right Table: Table on which the join is to be performed.
*Left Column Name: Text string that specifies the column or columns from Left Table on which the join is to be performed. If left blank, the row name, up to the first colon (if it contains a colon), is used instead of a column value.
*Right Column Name: Text string that specifies the column or columns from Right Table on which the join is to be performed. If left blank, the row name, up to the first colon (if it contains a colon), is used instead of a column value.
This function returns a table.
Example
The third table below is attached to the function defined by the following dialog. The first table’s data table is attached to the argument Left Table and the second table’s data table is attached to the argument Right Table.
Join Function example
Copyright © Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its Subsidiaries and or/its Affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.