How to handle Null in Insert Snap?
Hi,
My pipeline is running successfully when I have data in the source table. But when there is no data on the source then the Insert snap got failed with the message that the null value is not all...
Forum Discussion
Brian, if you copy/pasted from your environment to this post, the issue is likely the letter casing on your sort path.
Notice the casing Oncontact vs. OnContact.
For some reason, Sort doesn’t throw an exception for invalid sort paths
Thanks! Second set of eyes always helps! I’ll try that!
Max - what you're asking for is a Cartesian Product between the first and second outputs - basically every record from one path combined with every record from the other. You can do this using a Join snap configured as follows:
Hope this helps!
