--- schema_version: "1" id: 18770d1813e407023c21922571eee88f6de2a4bb0a6b47bd2afe37ecd67db879 title: Using the Case Node collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_using_the_case_node.md canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_using_the_case_node.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 60590c1c03c6ef25532b65335957c17f6c8847cfef0ec373608ee6345013eaa7 description: The case node, similar to the CASE statement in SQL, analyzes data by comparing the attributes of conditions. The WHEN/THEN statements determine the outcome based on whether all or any of the specified conditions are true. If none of the WHEN conditions are met, the ELSE statement provides an alternative action. The Case node statement must be followed by at least one WHEN/THEN pair, which applies a designated function when the associated condition is true. products: - Data 360 release: "264" --- # Using the Case Node The case node, similar to the CASE statement in SQL, analyzes data by comparing the attributes of conditions. The WHEN/THEN statements determine the outcome based on whether all or any of the specified conditions are true. If none of the WHEN conditions are met, the ELSE statement provides an alternative action. The Case node statement must be followed by at least one WHEN/THEN pair, which applies a designated function when the associated condition is true.

equal	Returns values that are equal to the specified value.
not	Returns values that are not equal to the specified value.
is null	Returns a null value when conditions are met.
is not null	Returns a not null value when conditions are met. For example, filtering a field to ensure that the value exists.
less than	Returns values that are less than the specified value.
less than or equal to	Returns values that are less than or equal to the specified value.
greater than	Returns values that are greater than the specified value.
greater than or equal to	Returns values that are greater than or equal to the specified value.
is empty	Returns empty values. For example, an empty string is a string with zero length.
contains	Checks if the given value can be found in the results.
does not contain	Checks whether the specified value is not present in the results.
contains regular expression	Checks whether the specified matching string is present in the results.
does not contain regular expression	Checks whether the specified matching string is not present in the results.