how to?

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

Input

Output

Best Practices

Data Investigation

Database Connection

Accepted answers

jordanmount6

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

All comments

jordanmount6

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703