How to check if Query returns empty?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2018 01:33 PM
Hi,
I have a sql execute snap that can return no values.
I have the pipeline continuing if there is no values.
What is the best way to identify if the query returns empty?
I have added a “select count(*)…” off of the query before running the main query but that seems foolish.
Any thoughts?
Bob
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2018 09:47 PM
Doing the select count seem to be the only way for now.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2018 05:59 AM
Meh.
Thanks!
