Question: Is CASE WHEN supported in DESelect?
Answer: Absolutely, through the use of Custom Values. Custom values allow you to define complex criteria (the WHEN statement) and define the value that needs to be selected if the criteria are true (the THEN statement).
Example: On Account, you store the industry SIC code. Instead of the SIC code, you want to refer to the name of the industry. These SIC codes can be translated into industry names using custom values.
More details on how this functionality works can be found below:
- Using fields in dynamic custom values.
- Add a dynamic custom value to your results.
- Validate gender values for your customers.