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.
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.
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.
