Derive – Conditional

Deriving a field as a conditional is similar to deriving a field as a flag except that, typically, the expressions tend to be more complex, as they usually involve multiple fields or specific values of a field. One of the most common methods of deriving a field as a conditional is to contrast a group of interest with others.

With regards to our data, from previous research we know that education is related to income. We also know that employment status is associated with income. We already have an education field and a field identifying the number of weeks that someone has worked. However, we do not have a field that combines these two pieces of information. In this next example, we will create a new field called Educated_fulltime, that will identify people that have either a bachelor's degree or an advanced degree and have worked for 52 weeks in the past year:

1. Place a Derive node onto the canvas.
2. Connect the Derive node named Age_Groups to the new Derive node.
3. Edit the...