Forum Discussion

Max's avatar
Max
New Contributor II
2 years ago

Move control to appropriate router after SQL statement returns no results

In this pipeline im taking 2 parameters and using them in a SQL select statement in the where clause. . I can have 1 of 3 out comes. I will return 1 result, 2 results or no results.  Im using the aggregate snap to evaluate how many results are returned from the SQL select, then based on the result passing to the appropriate router. This works great for the first  2 scenarios but i get errors when it tries to evaluate "no result" from the SQL select. Any advice as to how i can accomplish this?