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.
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?
