Use if-Switch to decide which database executor gets used

Hello,

In a Loop, I have a Loop variable, and depending on ist value I want to either execute branch 1 or branch 2. In both branches, there are just a number of Database SQL executors.

What if-switch can help me in this task? The “Database IF Switch (Flow Variable Value)” seems to not work since the ports do not fit together (“DatabaseConnectionPortObjectSpec” and “DatabasePortObjectSpec”).

Best regards

Try using the flow variable if switch, and connect the output to the invisible ‘Mickey Mouse Ears’ flow variable ports of your SQL executors. Alternatively, does the Database IF Switch (Flow Variable Value) have the correct port type for your application?

image

(It’s a bit difficult to see, but ‘Node 936’ is in an inactive branch)

Steve

3 Likes

Hey,

thanks, meanwhile I found the same solution and it works great :slight_smile:

Best regards

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.