Table
Contents
The Table node is generally used to store the parsed data for further analysis. This is a sample workflow with two types of tables for different usage:
▪Device Data Table (DDT) is exported from parsed variables in a Device or Command node. It only stores data for devices in the current loop and can only be referenced inside the Canvas node. The following table type is also a Device Data Table:
oSystem Data Table — built-in data types (including Route Table, ARP Table, MAC Table, NDP Table, STP Table, NCT Table), and only can be extended from a Command node. See Configuring system data table for more reference.
oDevice/Interface Report — used to store the device or interface attributes, and only can be extended from a Device node.
▪Global Data Table (GDT) is converted from a Device Data Table by the Convert Operator. It stores the data for all devices in the Device Queue. The variables in a GDT can be referenced by all Canvas nodes within a Qapp.
Configuring Device Data Table
1.Extend a Device Data Table node after a Command node. For how to extend nodes, see Extending a node for reference.
2.Click the 
icon between the Command node and the Table node to specify which variables will be included in the table.
For interface-level variables such as interface MTU, duplex and input/output errors, click Table>> to add them to the table. For device-level variables such as CPU usage, version, and memory size, click Attribute>> to add them to the attribute table.
3.Click the Table node to configure more table attributes if necessary.
▪Enter the table name and description.
▪In the table area, click New Column to create a new column. There are the following two types of columns:
1)Rename the column name, which is also the table header. 2)Specify the column type (string by default). 3)Enter the initial value of the column and Click OK. You can repeat the steps to add more columns to the table. |
This type of variable is calculated based on the existing columns in the table via formulas. Configure its property as follows: 1)Rename the column name, which is also the table header. 2)Specify the column type (string by default). 3)Enter the initial value of the column. 4)Enter the formula script, such as $cell = $column1 + $column2. 5)Click OK. |
Tip: The attribute table pane on the right displays the built-in system attributes as long as you retrieve the live data via CLI in the Command node. When you convert the table to a Global Data Table by using the Convert Operator, the table attribute $_device will be added as a new column in the Global Data Table.
Configuring System Data Table
Note: The following instructions take a Route Table for example. You can also follow the steps to configure other types of System tables.
1.Extend a Route Table node from a Device node. For how to extend nodes, see Extending a node for reference.
2.Click the Route Table node to configure more attributes based on your needs.
1)Modify the node name if necessary.
2)Enter a description of the node in the Description field.
3)Select a branch to apply if multiple branches are created in the Device node.
4)Select the data source from the drop-down list.
▪To retrieve live data, select Live Network. You can click Retrieve to select a device in your domain and retrieve its live data.
▪To use the latest device data saved in the database, select Current Baseline.
▪To select data source when running the Qapp, select Use Option in Run Qapp.
5)For other settings, see Table settings for reference.
Next node: