SQL Like Case
This will perform a SQL like SELECT with given WHEN – THEN case. Example: “WHEN Quantity Ordered > 40 THEN ‘a’ WHEN Quantity Ordered > 30 THEN ‘b’ ELSE ‘c'”
The settings are:
Column to store result: Name of the column the data will be stored in
SQL Case (optional): When your WHEN….THEN…. statement in here. Make sure column names are spelled correctly (case sensitive) and the condition you want entered is in single quotes.