Flipping Signs

In data load rules files, you can reverse the values of data fields by flipping their signs. Sign flips are based on UDAs that are defined in the outline.

  To flip data-field signs while loading data:

  1. Open or create the rules file.

  2. Select the field to flip.

  3. Select Options, then Data load settings.

  4. In the Data Load Settings dialog box, select the Data Load Values tab.

  5. Expand the Sign Flip node.

  6. Select On UDA.

  7. If the Dimension node is empty, click the Outline button to associate the rules file with an outline.

  8. In the Dimension node, double-click the dimension containing the UDA.

  9. In the text box, enter the UDA that is required to flip the sign of the selected field.

  10. Click OK.

Related Information