Conditional columns interface

The Query Editor provides a basic and advanced conditional column interface as an alternative to writing out the if...then expressions.

Any column from the table can be referenced and multiple steps created can be moved up or down the order of evaluation.