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
- From the Navigation or Project View, right-click the File Update process and select Edit Process. The process editing window opens.
- Select the Input Conditionals or Output Conditionals menu option.
- Right-click in the right window and select Add > New > Attribute Transformation. The Set Attribute window opens.
- Enter a brief Description for this transformation rule.
- From the Set Attribute list box, select the name of the attribute. This is the attribute to which the transformation rule is applied.
- 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.
- After you build your expression, click Finish.
- Repeat Steps 3 through 7 to define another attribute.
Insert a condition
To insert a condition