Output Settings - trillium_discovery - trillium_quality - 17.2

To establish the output settings

1. In the Navigation or Project View, expand the project with which you want to work, and expand Processes.
2. Right-click File Update and select Edit Process.
3. Select the Outputs tab.
4. Check the box next to the first file you want the program to create. (The table below describes each option.)
5. (Optional) To filter the records that are put into this output file, click Settings. The Row Filter window opens.
6. Click the Build expression... button ( ) . The Set Row Filter Expression Builder window opens.
7. Build the filter expression. For more information, see Filtering Rows Using the Expression Builder.
8. Click OK
9. Click Back to return to the Outputs window.
10. Repeat steps 4 through 8 for each file you want the program to create.
11. (Optional) Change the Debug option. (The default is off.) For more information on Debug mode, see Debug Settings.
12. Click Finish.

    Output file options:

    Output File Options	Description
    Matched Master Rows	The program stores rows from the master file that have the same match key value as the rows in the transaction file.
    Matched Master Duplicates	The program stores additional rows with the same match key value. By default, only the first match is put into the matched master rows file. Note: If you enable this output file, you must decide if you want to update these duplicate rows. By default, duplicates are not updated. To change that setting, click Update Matched Master Duplicate Rows.
    Combine Matched Master Duplicate Rows with Matched Master Rows	Select this box if you want to store the matched master duplicates to the same file as the matched master rows. Note: If you enable this output file, you must decide if you want to include duplicate transaction rows in the combined output file. By default, the utility updates only the first matched row, even if you combine the matched master rows with the matched master duplicates. To change that setting, click Include Duplicate Transaction Rows.
    Unmatched Master Rows	The program stores rows from the master file that do not have the same match key value as the rows in the transaction file.
    Combine Unmatched Master Rows with Matched Master Rows	Select this box if you want to store the unmatched master rows to the same file as the matched master rows. Note: This checkbox is selected by default if the project was created in an earlier version of TSS (before TSS 14) and the project is using the same file for the matched master rows and matched master duplicates.
    Unmatched Master Duplicates	The program stores rows from the master file that do not have the same match key value as the rows in the transaction file, and are duplicates of a row that is in the unmatched master rows file.
    Combine Unmatched Master Duplicate Rows with Matched Master Rows	Select this box if you want to store the unmatched master duplicate rows to the same file as the matched master rows. Note: This checkbox is selected by default if the project was created in an earlier version of TSS (before TSS 14) and the project is using the same file for the matched master rows and matched master duplicates.
    Matched Transaction Rows	The program stores rows from the transaction file that have the same key value as the rows in the master file.
    Matched Transaction Duplicates	The program stores additional rows with the same key value. By default, only the first match is put into the matched transaction rows file.
    Combine Matched Transaction Duplicate Rows with Matched Transaction Rows	Select this box if you want to store the matched transaction duplicates to the same file as the matched transaction rows.
    Unmatched Transaction Rows	The program stores rows from the Transaction file that do not share the same key value with any rows in the master file.
    Combine Unmatched Transaction Rows with Matched Transaction Rows	Select this box if you want to store the unmatched transaction rows to the same file as the matched transaction rows.
    Unmatched Transaction Duplicates	The program stores rows from the transaction file with a different key value than rows in the master file that are duplicates of a row that is in the unmatched transaction rows file.
    Combine Unmatched Transaction Duplicate Rows with Matched Transaction Rows	Select this box if you want to store the unmatched transaction duplicate rows to the same file as the matched transaction rows.