Input and Output Conditionals for File Update - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

The File Update utility updates the master file with the data contained in the transaction file. You can add an Attribute Transformation or insert a condition for attributes in the input and output data. The File Update utility only processes records when the conditions are met, although you can run the utility without setting a condition.

Add an Attribute Transformation

To add an Attribute Transformation

  1. From the Navigation or Project View, right-click the File Update process and select Edit Process. The process editing window opens.
  2. Select the Input Conditionals or Output Conditionals menu option.
  3. Right-click in the right window and select Add> New >Attribute Transformation. The Set Attribute window opens.
  4. Enter a brief Description for this transformation rule.
  5. From the Set Attribute list box, select the name of the attribute. This is the attribute to which the transformation rule is applied.
  6. Click the Build expression... button (). The Expression Builder opens. Set attributes using the Expression Builder. You can also enter the expression directly into the to expression window.
  7. After you build your expression, click Finish.
  8. Repeat Steps 3 through 7 to define another attribute.

Insert a condition

To insert a condition

  1. From the Navigation or Project View, right-click the File Update process and select Edit Process. The process editing window opens.
  2. Select the Input Conditionals or Output Conditionals menu option.
  3. In the left window right-click a condition and select one of the following:
    • Insert > Condition Before... to add a condition before the current condition
    • Insert > Condition After... to add a condition after the current condition
    • Insert > Sub-condition... to add a sub-condition to the current condition

    The expression builder opens. See Setting Conditions Using Expression Builder for information on how to build conditional expressions.

  4. After you build your expression, click Finish.
  5. Repeat Steps 3 through 5 to define another condition.