how to?

[ravi061]

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

[jordanmount6 · Accepted solution]

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]

Hi, @ravi061 

The Control Containers tool in v2023.1 just for your case .

[ravi061]

Hi @flying008,

I don't have 2023.1 version with me, but i have 2022.3 version