Comparing 2 string values

Question

HelloI'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 wellAny 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

ShrawanSaxena-1 · Accepted Answer

Hello,You can use a case construct to compare two null values in filtering conditionsFor example I am comparing first name and last name on equal operatorCase(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

sivaramakumar_P · Answer

Can you able to share some sample code which you used.. did you tried in sys filters or some other attributes of schema?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded