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 agg...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
2 years ago

Max 

If there are no results from the Select, than I don't see any point of counting the records(when there are no records returned). So after Select snap, you can add Router snap and check if there are records returned or not.

 - If there are records, then go to the Aggregate Snap, and next router (after Aggregate snap, which now will have only 2 branches - when there are 1 or 2 results).

 - If there are no records returned from Select Snap, not route to the Aggregate Snap, and procced on the branch that supposed to be used in case of no records.

  • Max's avatar
    Max
    New Contributor II
    2 years ago

    I have removed the aggregate snap and connected the router snap to the SQL select snap, Now from the router snap, how to you check to see if there are results returned from SQL select snap?