I'm stuck with something that should have been easy to do: I need to compare 2 values and do different things depending on the result.
The 2 values type are string.
My first idea was to use a simple "equal" condition in the filtering window.
But checking the result, I realised that 2 empty field were seen as "non-equal" whereas they should have been equal.
I tried to use the IfEquals function but no luck as well
Any idea how to simply check if 2 fields as identifical ? Assuming that a null field is equivalent to an empty field ?
Thanks for your insights
You can use a case construct to compare two null values in filtering conditions
For example I am comparing first name and last name on equal operator
Case(When(Lower(@firstName) IS NULL , 'Null') , Else(Lower(@firstName))) = Case(When(Lower(@lastName) IS NULL , 'Null') , Else(Lower(@lastName)))
Above condition will return recipient records where firstname is equal to lastname or both firstname and lastname are null
Thanks for your help, it works fine !
Can you able to share some sample code which you used.. did you tried in sys filters or some other attributes of schema?