Method 2—Filter Each Record Type During Entity Creation - trillium_discovery - trillium_quality - 17.1

To manage multiple record types with a filter

1. Make sure that there is one COBOL copybook for each record type that exists in the data file.

2. Once you have split your copybook to represent each of the record types, follow the steps for creating an entity. (This procedure is described in Trillium Control Center online help.)

3. When asked to select a data file, choose the one that contains the multiple record types.

4. When asked to select a corresponding schema, choose one of the copybooks (that you created) to represent a record type.

5. When you get to the schema settings window, apply the schema settings and click Preview. The data displays in the pane below the wizard. From this pane, you can organize how the data should be represented in the new entity.

6. From the preview pane below the wizard, right-click and select Filter.

7. Build a filter expression to select the record type that corresponds to the copybook and click Apply.

   Note: See the Trillium Control Center online help for information on filtering.

   Only records with a single record type should show in the preview pane.

   Example

   Assume the following:

   • Record type field is REC-TYPE
   • Valid values for REC-TYPE are H, D, or F
   • Selected copybook describes records with a REC-TYPE of D

     You would build a filter expression that looks like:

     REC-TYPE = D

8. Continue with the Create Entity Wizard.

9. After the entity is created, repeat steps 3-8 to create an entity for each record type.

Example