Entity-based Recode Tables - trillium_discovery - trillium_quality - 17.1

Entity-based recode tables allow the user to load an existing entity (real or dynamic) in the repository and use its attributes for recoding. This method can also be used when you have a quality project that has already been run to generate the recode data, and you want to use the same recode values or masks in a subsequent project.

To generate an entity-based recode table

1. From the Navigation or Project View, right-click the Transformer process and select Edit Process. You can also double-click the process to open it for editing.
2. Select the Output Conditionals tab.
3. Right-click within the Transformation Rules pane (right-hand side) and select Add > New > Table Recode.
4. Enter a description for this table recode operation. The description will be inserted in the Statistics File.
5. Select Entity as the source of recodes.
6. Select the entity containing the recodes that you want to use.

   If you select a dynamic delimited entity, you must define the maximum lengths for the attributes in the entity. Click Adjust attribute length and specify maximum width (in characters) for each attribute and click OK. The Adjust attribute length feature also has a Set All option.

7. Click Show Data to display the entity in a list view.
8. Review the data and the effect they have on the attribute's values. When you are satisfied with the recode, click Next.
9. Select the attribute from the Match attribute list. This is the Transformer output attribute which will be matched against the original value in the recode entity specified in Step 6.
   Note: You can match up to five (5) attributes. Specifying multiple attributes creates an AND condition for the table recode operation. See Recoding Data Using Multiple Attributes.
10. Select the attribute from the to recode attribute list. This is the attribute in the recode entity where the original values are described.
11. Select the recode type (literal or mask). Click Next.
12. Select the attribute from the Copy recode attribute list. This is the attribute in the recode entity that contains the new values.
13. Select the destination attribute from the to attribute list. This is the Transformer output attribute which will store the recoded value.
14. Select the recode type (literal or mask).
15. (Optional) Select Case sensitive matching to use case-sensitive matching. By default, matching is case-insensitive. The case sensitive option does not apply to masks, only to values.
16. Click Finish. The scheduler notification bar opens.
17. (Optional) Change the job name.
18. Do one of the following:
    • To schedule the job to run immediately, click Now. The message closes and the job begins running in the background.
    • Click Later. The Set Date & Time scheduler window opens. To immediately run the job in the background, click Run Now. To schedule a time, select a starting date on the calendar and select a time you want the job to run on the selected date. Click Submit to save the scheduled time.
    • Click Cancel to cancel the task.
    Note: All scheduled jobs are run in the background. Note the progress in the Background Tasks List View.

    The recode table and its ddx file will be created in path \ repository_name \projectN\tables , where path is the path to the repository directory (specified during installation), repository_name is the name of your repository and N is the number of your project. For example, C:/ProgramData/Trillium Software /.../repository1/project1/tables.

    When the Transformer is run, it will apply the recodes to the output attributes.