Forum Discussion
If you want to stop the flow(in case SQL Select does not return anything) then you can do that by using Filter Snap(ex: with condition if that CustomerNbr field exist. ex: $.hasPath("CustomerNbr")).
Thanks for the reply, i am not getting correct example on match that uses multiple columns. please can you share me some example and also in mapper if i use match, it is giving error. please can you share me some example on match that use multiple columns.
Thanks again
Hello, thank you for your response. Im trying to continue on with the flow if the SQL select snap does not return a result. The flow stopping if there is no result, is the problem. The goal here is, if there is one result go the the first router output, if there are 2 results move to the second router output, if there are no results returned from the SQL select snap then move to the third router output. Given what im trying to do, is the aggregate snap the correct way of doing this or is there a different/better way to get where im going?