Define Sub Table

The system supports defining sub table for you to filter the noise data from the base table. For example, analyze the route entries related to the critical application subnet in the device route table and ignore the changes of other dynamic routes. You can filter the rows by either keeping or removing the value at the specific columns routes, reducing the noise alert that may appear in diagnosis.

Further, you can remove some unwanted columns and add some columns to describe auxiliary information.

Define a sub table as follows:

1. Enter the Table Name: The naming rules must meet the naming rules for variables.
2. Select a Base Table: Select a parser table (except the compound table) in the current NI.
3. Define the Filtering Logic: Define the logic for filtering from the base table. First, select Only Keep or Only Remove, and then choose the columns in the base table.
4. Filter rows by Predefined Global List and Manually Specified Values. They are the sources to define the filtered data: the global table or manually defined.

Filtering Logic

Filter Logic defines the logic for generating the sub table from the base table.

• In the first drop-down list, the Only Keep and Only Remove options are provided, indicating whether to keep or remove from the base table.
• The second drop-down list shows the columns of the base table, which indicates that the row data corresponding to the selected column is used for the comparison.

Filter Rows by Predefined Global List

Predefined Global List allows you to select an existing global table:

You can preview the top 10 rows of the global table. Click the Open link to open the global data manager and view all the data. You can also define the mapping relationship between the columns of the global table and the columns of the selected base table through Column Mapping, indicating that the data of the column specified in the global table is used for comparison.

The columns of the selected base table are displayed in the Base Table, and the columns of the Global Table are displayed in the Global Table.

Filter Rows by Manually Specified Values

Manually specified Values allow you to define a list manually, and the columns of the selected base table will be added automatically.

You can also add more columns.

Clicking Add Row can add blank rows, and hovering over the cells will show the edit icon. You can click this icon to enter values.

Advanced Settings

Click Advanced Settings to select the columns in the sub table. By default, all the columns are selected.

• When Only Keep is set in Filtering Logic, the selected columns include all columns of base table, and all columns of the global table or manually added columns in Manually Specified Values. The columns of the global table and manually defined table are highlighted by color.
  
  

  Note: The selected column (key column) of the base table is not allowed to be deleted, and the mapping column set in the global table is not included in the sub table.

• When Only Remove is set in Filtering Logic, only the columns in the base table are displayed.