How to run dynamic query when the pipelines doesn't have data & complete the workflow

Question

I am doing some an in-depth processing of data from one database which results in few or no exceptions.

I use a dynamic query to bring some fields from another database and do further processing.

The issue is when I have no data resulting in an exception - the dynamic SQL query fails. What's the best way around this problem?

My dynamic query is simple & complies all the incoming exception IDs into a list using cross-tab& passes it in the query:

Select * from abc

where data = '20221205'

and ID in ('898989', 99999')

I appreciate any help and suggestions.

gelvira · Answer

Thanks! That's a good idea. Let me try and see if I can make it work.

gelvira · Answer

Thanks for you quick reply.

So my use case looks like this.

In the top flow I have the same two columns but no data as it resulted in no exceptions and I get an error on ConnetionFile & query.

The bottom flow works perfectly whenever I have 1 or multiple results in it.

What is the best way to complete the workflow without error in this case?

apathetichell · Answer

you can throw a count with your first tool. when count != 0 your macro which contains your second query runs otherwise it is skipped.