Adding Expression Operations

Most operations have an editor that allows you to define expressions.

To transform your data using Expression

1. Create your transform, for instructions, see Creating a New Transform.

2. From the Transformation Editor palette, select Expression.

3. Click and drag the mouse anywhere in the Model tab.

4. Double-click the Expression operation that you just added.

5. Use the editor to specify your expression syntax. For example, type syntax similar to any of the following:

— salary < 50000

— EMP > 34

— {http://biz.com}customer/biz:orderID < 900 AND NOT {http://biz.com}customer/biz:customerID = 20

— Sales/finalsale > 1000

If your expression contains illegal characters you must enclose them in double quotes. The following characters are considered illegal:

'\\', '[', ']', '-', '(', ')', '.','^','$','+', '*','?', '{', '}', '|', ':', '<', '>', '<', '='

6. Save your transform.