Browsing a Data File with a DDL - trillium_discovery - trillium_quality - 17.1

You can browse the contents of a data file with a corresponding DDL file.

To browse a data file with a DDL

1. Select File > Open with Dictionary. The File Selection Dialog window opens.
2. Enter the file path for both the DDL and data files, or browse and select the files.
3. Click OK. The Field Selection window opens. This window shows all the fields that exist in the DDL. You can sort the fields by clicking the Field Name, Start Position, Length or Type column headers.
4. Do one of the following:
   1. To select all fields in the record, click Add All. All fields appear in the Selected Fields list.
   2. To select a particular field or fields, highlight the field in the Field Name list and click Add. The selected fields appear in the Selected Fields list.
      Note:

      • You can sort the data by clicking the column headers such as Field Name and Type.
      • The order of the fields determines the order in which they display when you browse the records.
      • To find a field quickly, enter the field name in the Search by box and press Enter. The field will be highlighted.
5. Optional: Use the following buttons to move, delete, load, or save the fields. To clear all fields in the list to start over, click Clear.
   Note: To select multiple fields in the list, press the Shift key and highlight the fields.

   Button	Description
   	Move up the position of the field(s) in the list.
   	Move down the position of the field(s) in the list.
   	Delete the field(s) from the list.
   	Load a saved view. This button is enabled when there is a saved view. Click . The Customized View window opens. In the Customized View window, select the view name on the left section and click OK. The fields will be loaded in the Selected Fields window. In the Customized View window, select the view name on the left section and click OK. The fields will be loaded in the Selected Fields window. Note: If the DDL does not match the saved view, the fields are displayed in blue in the Customized View window. You cannot use the unmatched fields. Select Display to view the stored fields.
   	Save the selected fields (called the "view") in a file. Click . In the Save window, specify the file name. In the Save window, specify the file name. Note: The view file will have the extension of .cuv. By default, the file will be saved to the DataBrowser folder in the <install path>/server/metabase/etc. We recommend that you not change this location. Click Save.

6. Click Display. The Data Viewer window displays. Selected fields are displayed in a spreadsheet format. Each column represents a field in the data file and each row represents a record.
   Note:

   • When the data in the file does not match the corresponding DDL file, you will see an asterisk (*) in the title bar of the Data Viewer. The data that does not match the DDL file are displayed in pink.
   • You can drag and drop the column headers to move the fields.
7. Optional: You can change the view by selecting the browse option in the Browse menu. The following options are available:
   • Browse Data on Record Level: The data are displayed by record number. This is the default.
   • Browse Data in Hex: The hex information is displayed for each record.
   • Browse Data on Field Level: Details of data for each record such as field name, type, position and length are displayed.
   • Show Error: The data that does not match the DDL file are displayed in pink.

   You can also display the data by Record Numbers or Byte Offsets. Click either option from the Options menu.

   Note: Offsets are 0-based.
8. Optional: To view a specific record, enter the record number in the Go to Record field and click Go.
9. Optional: If changes are made to the file in other editing tools, while it is still actively open in the Data Browser, select File > Reload to update the views.