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

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:53:20.448228
Note: Only apply this method if the following are true: the Data file is delimited with line feeds and Record types all have the same length.

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