Build Column Group with Data from Imported CSV

If a local CSV file containing data is ready to be used in ADT, the CSV file can be imported and used to create an ADT base table. By default, all columns in the CSV are added as available fields in ADT.

To build the base table via the data in CSV, follow the steps below:

Prerequisites: Create a CSV file.

1. Open Automation Data Table, then create a new table and name it.
   
2. Click Table Builder to open Automation Data Table Builder of the created ADT.
   
3. Under the Define Additional Column Groups tab, define the following settings:
   
   
   1. Select Method to build column group: Select Data from Other Table > Imported CSV.
   2. Description: Input descriptions (for example, Check bad interface parameter) for the base table to describe its use and function.
   3. CSV: Select the created CSV file to import and use. You can import the CVS file in two ways, Import from Local and Import from My File. Select any option, and then click Browse to Select CSV file form the window (for example, the CSV file "Bad Interface Parameters Interface Checks for CSV NIC 1.csv") to be used.
   4. Define paired keys: Click Add Keys, then select one column from the imported csv and one ADT column to form a paired key. The csv data will be added to the current ADT by referencing this paired key. You can add one or more paired keys. 
        
      

4.  Mapping Available Fields in CSV to Column Group: Drag and drop the available fields to the column group definition area to create ADT columns automatically. The columns of the imported CSV will serve as available field for building the current column group. 
   
   

5. Click Save to save all the settings. But table data is not built. 
6. Click Save and Build. The Build Table dialog appears, define the settings as per your preferences. This will save the table and build the table data.