I need to query database with list of queries sequentially and process them distinctly . I am using loop to to execute the queries and need to proceed to next query if the response of the earlier query in the loop is empty. Used empty table switch , but still facing error stating of active node error on loop end … How can I move to next set query , attached my workflow. Appreciate help on resolution of the same .
Hi @JPollet , I have quite a lot processing to be done if DB returns records and then write processed records into individual excel files . . If I use loop end instead of variable loop with end if output port connecting to next logical node, I will get exceptions in the intermediate process nodes due to no data
At a glance, I’m not sure why you’re connecting both the flow variable from the Column Filter AND the End If nodes to the Variable Loop End. This shouldn’t be necessary, and might be “confusing” the Loop End and throwing the error. But it’s hard to know based on screenshots alone.
I think @ScottF is right. Remove the variable connection from column filter to loop end node
(and as he also pointed out with data it’s always easier to debug)
br