Importing a field

Use this procedure to import a field in the data structure. When importing a field or several fields, the settings for the fields are transferred into the data structure.

  1. In the Fields pane, click Import. The Select Fields window is displayed.
  2. Select the table you want to view fields for. The fields are displayed to the right.
  3. Select the table from where you want to reference the field or column. All fields in the table are displayed in the right panel. The field name, its field characteristics, and connected field heading are pre-filled for the field to be added. It is possible to change the field metadata according to your preference.
    Note:  You can filter the display based on field names by specifying any character in the first text box. All the fields containing the specified characters are displayed. Alternately, you can choose to filter by description by specifying the description criteria in the second text box.
  4. Select one or more fields that you want to import.
  5. Click OK. The Import result window is displayed with information about the imported fields and the new field names.
  6. Click OK. The Fields pane is updated with the new fields. The imported fields will acquire the prefix of the first field in this pane.