How to use join snap to get NOT a match data
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’...
Forum Discussion
Hi Can anyone help me with this?
Hi @dd_snaplogic,
The two entities that you’re trying to compare, should be of the same data type. Adding a !(not) in front of your $abc field which I presume is of a type String, will turn that field into a boolean value - false. So you’ll end up comparing boolean and string.
If I understand correctly, you want the records that do not match? If that’s the case, you can open an error view on the Join snap, and select the ‘Unmatched data to error view’ option:
Hope this helps,
Regards,
Bojan
