SOLVED
how to?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ravi061
8 - Asteroid
‎09-27-2023
08:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have a requirement, in oracle we have two sql queries, first query will show the record counts, if the first query has 1 or more records, then second query should be running and second query output should be written on the excel , if first query produces zero records then second query shouldnt be run, how can i do Workflow?
Thanks,
Ravi Teja
Solved! Go to Solution.
Labels:
3 REPLIES 3
jordanmount6
8 - Asteroid
‎09-27-2023
09:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't know of a native way to do this in Alteryx but i think you could accomplish this a different way by using some combination of a formula tool and dynamic input tool for the 2nd query.
This should give you a good idea of what i mean.
https://community.alteryx.com/t5/Engine-Works/Creating-a-Custom-SQL-Query-Builder-App/ba-p/893385
flying008
15 - Aurora
‎09-28-2023
12:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-28-2023
01:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator