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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Comparing 2 string values

associationp157
Level 2
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
shrawans3153003
Correct answer by
Employee
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
shrawans3153003
Correct answer by
Employee
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

sivaramakumar_P
Level 2
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?