R12.1-JA-2025June05

Build Base Table with Merged ADT

The Merged ADT method of building base table from other ADT is introduced. Two or more ADTs are joint by ‘full join’ or ‘inner join’ method to form a new ADT. Since many ADTs can be joint by the ‘Merged ADT’ method, this method makes ADT creation extremely scalable.

Define Base Table via Merged ADT

To build the base table with the data of anther ADT by merging data, follow the steps below:

Prerequisites: Create an ADT containing useful data in advance.

  1. Go to Automation Data Table Manager, then create a new table and name it.

  2. Click Table Builder to open Table Builder.
  3. Under the Define Base Table tab, define the following settings:

    1. Select Method to build Base Table: Select Data from Other Table > Merged ADT.
    2. Description: Input descriptions for the base table to describe its use and function.
    3. Add Table: Select several existing ADT for building the base table. Click +Add Table to select the ADTs to be merged. 
    4. For each selected ADT, select ADT columns as paired key, which will be used for merging data from these ADTs. 

    5. Click the   icon next to Full Join to select a table merging rule. The table merging rule that is selected applies to all the selected tables. 

      • Full Join (Keep all rows in both tables): keep all the rows of the tables while merging tables.  
      • Inner Join (Only keep the rows with matching key): Only keep the rows of tables having matched keys.
  4. Mapping Available Fields to Column Group: Drag and drop the available fields to the column group definition area to create ADT columns automatically.

    There are three field categories in this area to be selected.
  • Paired Keys: The Paired Keys field contain the paired key data and is the necessary table key. 
  • Source Table Fields: The columns of each source table will become available fields. These fields are grouped by the source tables. 
  1. Filter Row: Select sites or device group for filtering the data in the table row.

  2. Click Save and Build to save all the settings and build table data. You can define the build settings. 

  

Build Base Table with Data from Other Table Build Base Table with Subset of ADT