Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Comparing 2 string values

Avatar

Level 2

Hello

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

1 Accepted Solution

Avatar

Correct answer by
Employee

Hello,

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

View solution in original post

3 Replies

Avatar

Correct answer by
Employee

Hello,

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

Avatar

Level 2

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