Table Operator

The Convert Operator converts a Device Data Table (DDT) into a Global Data Table (GDT).

1)Click the Convert node in the workflow.

2)Click Calculate to view the converted table data.

The Sub Table Operator filters table data by customized conditions. The data matching the conditions are saved as a new table.

1)Click the Sub Table node in the workflow.

2)Select the columns that you want to keep. By default, all columns are selected.

3)Click Calculate.
Example: A result of removing rows which meet the conditions in the new table.

The Delta Operator calculates the difference of a specific variable between two recurring periods.

Note: It is only applicable to the Device Data Tables in a Monitor Qapp (that is, a Qapp with Monitor Output).

1)Click the Delta node in the workflow.

2)Select a key to identify the variables for delta calculation.

▪If the variables are interface attributes, such as input errors, select the interface name as the key.

▪If the variables are device attributes, such as CPU usage, select the device name as the key.

3)Select table columns for delta calculation based on your needs.

4)Click Calculate. Here is a sample result:

The Neighbor Join Operator matches the keys of two Device Data Tables against the neighbor relationship and integrates the data in a new table to show the relationship.

Note: It is only applicable when you select Neighbor Pair as device input in the Device Queue node and extend related neighbor device nodes.

1)Click the Neighbor Join node in the workflow. The matched keys in two tables are displayed in the bottom pane. You can click each table name to view the table details.

2)(Optional) If you want to adjust the matching keys, point to a key and click the icon to select a new key.

3)Click Calculate.

The Merge Operator merges the rows of two Device Data Tables into a new table based on the variable they have in common.

Note: It is only applicable when the two Device Data Tables come from the same branch.

1)Click the Merge node in the workflow.

2)Click Add Key, then point to a key and click the icon to select one common key for both tables.

3)Click Calculate.
Example: A result of merging rows by the interface key (collision and crc in Table1, and output_error and input_error in Table 2) into table 3 by the common variable intf:

The Append Operator appends column values of a table into the specified column of another Device Data Table.

Note: The Append operator is only applicable when the two device data tables are from the same Device node.

1)Click the Append node in the workflow.

2)Click Specify Column, then point to a variable of the Primary table and click the icon to select the column that the data from the Secondary table will append to.

3)Point to a variable of the Secondary table and click the icon to select the column you want to append its data to the Primary table.

4)Repeat step 2) to 3) to specify more columns.

5)Click Calculate.
Example: The data of output_error column from Table 2 is appended to the collisions column of Table1.