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

associationp157 · Answer

Thanks for your help, it works fine !

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded