R12.1-JA-2025June05

Build Base Table with Subset of ADT

A new smaller sub-ADT can be built from an existing ADT (i.e., the source table) by this Subset of ADT method. The new sub-ADT data is extracted from the source table to serve for special purpose, such as debugging intent column. After subset table is defined, the data of the source ADT will be copied as the base table data of the new subset ADT. 

Define Base Table with Subset of ADT

To build the base table with the data of anther ADT (source ADT) by extracting data from the source ADT, 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. Go to Automation Data Table Builder> Define Base Table tab of the created ADT.
  3. Under the Define Base Table tab, define the following settings:

    1. Select method to build base table data: Select Data from Other Table > Subset of ADT.
    2. Description: Input descriptions for the base table to describe its use and function.
    3. Source Table: Select an existing ADT to extract its data for building the base table.
    4. Filter Row: Define settings to extract row data of the source ADT by two approaches: Via Empty Cell/By Advanced Filter.
      • Via Empty Cell: This method is selected by default, then select some intent columns from the source table. if all cells in the selected intent columns are empty in one row, this row will be excluded from the final ADT. 
          
      • By Advanced Filter: Select By Advanced Filter option and click Add Condition, then define match condition to find data. 
  4. Mapping Available Fields to Base Table Column: Drag and drop the available fields to the base table column definition area to create ADT columns automatically. All columns of the source table can serve as available fields. 

  1. Click Save and Build to save all the settings and build the base table data.

  

Build Base Table with Merged ADT Build Base Table with Imported CSV