Skip to main content
Reshapes a value first, then runs your conditions against the reshaped result. Use this when the value you actually want to test is not the value you start with, for example lower-casing a status before comparing it so that ACTIVE, Active, and active are all treated the same, or trimming stray spaces before a check. The conversions run first, in order, and then every condition is checked against the final converted value.

​
Fields

​
Sample data

Here the value is lower-cased first, then checked against the text active. Because the conversion runs first, mixed-case input still matches.