Apama 10.15.0 | Building and Using Apama Dashboards | Dashboard Function Reference | Tabular Functions | Combine
 
Combine
Returns the result of combining two specified tables into a single table.
Usage notes
When Combine Rows is 0, the result contains the columns from Table 1 followed by the columns from Table 2. Each result row consists of the nth row from Table 1 followed by the nth row from Table 2. If Table 1 and Table 2 have a different number of rows, trailing result rows are padded with cells that are contain 0 or the empty string.
When Combine Rows is 1 and Ignore Column Names is 0, the result contains the rows from Table 1 followed by the rows from Table 2. The result table contains the column labels from Table 1 followed by the column labels that appear only in Table 2. In the result table, 0 or the empty string appears in cells that are in rows from one table and in a column that appears only in the other table.
When Combine Rows is 1 and Ignore Column Names is 1, the result contains the rows from Table 1 followed by the rows from Table 2. The result table contains only columns that appear in both Table 1 and Table 2.
Arguments
This function has the following arguments:
*Table 1: Table to be included in the combination operation.
*Table 2: Table to be included in the combination operation.
*Combine Rows: Numerical value that determines whether rows or columns are merged. When Combine Rows is 0, the result contains the columns from Table 1 followed by the columns from Table 2. When Combine Rows is 1, the result contains the rows from Table 1 followed by the rows from Table 2.
*Ignore Column Names: Numerical value that determines which columns are included in the result. When Combine Rows is 1 and Ignore Column Names is 1, the result table contains only columns that appear in both Table 1 and Table 2. When Combine Rows is 1 and Ignore Column Names is 0, the result table contains the column labels from Table 1 followed by the column labels that appear only in Table 2. This argument is ignored when Combine Rows is 0.
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 Table 1, and the second table's data table is attached to the argument Table 1.
Illustration showing the Edit Function dialog Illustration showing tables