cancel
Showing results for 
Search instead for 
Did you mean: 

How to use join snap to get NOT a match data

dd_snaplogic
New Contributor II

I’m using join snap to with a condition NOT, surprisingly the validation is giving me output, but when i’m running the pipeline it is giving me an error, Can someone please help me understand what i’m doing wrong
ERROR message: Not comparable objects: String abc and Boolean false

image

5 REPLIES 5

koryknick
Employee
Employee

@dd_snaplogic - If you can find a case where this is working the way you originally described, I would be very interested. The snap always uses an equality join, so “left path value == right path value” is the only way this snap works. By adding the not operator (!) to either of the values would simply make it a boolean value meaning that it evaluates as true only when the incoming value is null, zero, or empty string.

I’m checking with our developers, but perhaps the snap’s datatype checking has been improved so that it is now throwing the error that boolean is not comparable to a string value. But the evaluation still would not have been the behavior that I believe you were intending. (i.e. “true” == “abc” )