Derive – Flag

Deriving a field as a flag is similar to deriving a field as a formula except that the expression you create will ultimately result in one of two categorical values. One of the most common methods of deriving a field as a flag is to identify whether something of interest has occurred (for example, purchasing a product, visiting a website, and so on). In this example, we will take the Stock_numbers field and collapse it into those people who have an investment and those that do not:

1. Place a Derive node onto the canvas.
2. Connect the Stock_numbers node to the new Derive node.
3. Edit the new Derive node.
4. Type Investment in the Derive field textbox.
5. Click Flag on the Derive as drop-down list.
6. Click the Expression Builder button.
7. Double-click on Stock_numbers in the Fields list box.
8. Click the greater than (>) button.
9. Type 0.

10. Click OK:

This equation is saying that if someone has a value greater than zero on the field Stock_numbers, the Investment field will be assigned the value T, otherwise...