check condition

[kotlapullareddy]

Hello,

I’m trying to understand a simple scenario in KNIME workflow.

I have result set which give me either True/False condition. based on this I need to perform certain operation.
let say, if resultant Values is TRUE then, no need to do anything. else (resultant value False) should read the data.

[denisfi]

Hi @kotlapullareddy ,

For it, you can use the rule engine to test your quest and set true or false value or anything else like it… 0/1, S/N… with row split, you can set the default value to top row path and other value to bottom… after that, you can go on…

Other tip is set the rule engine value as “top” and “bottom” and then use the If node to direct the flow… BUT the value need to be passed as flow variable, so you need to use the table row to variables to set it before the if node.

That’s some examples for it. ok?

Tks,

Denis

[mlauber71]

@kotlapullareddy you could take a look at these case/switch example:

How can I avoid having to open and close a database connection twice when working with a sub-workflow that is only called when a certain condition is met?

@MgntMoe I still think you would have to think about your approach. I built an example where in a loop at every iteration there would be a check if in the chunk there would be a row with fault=1. In this case, the faulty lines would be exported to a separate sheet in an Excel file. Otherwise, just the number of fault lines would be shipped. Maybe you can take a look. It also uses SQLite as a sample database. [image] kn_example_switch_case_store_file_sql.knwf (158.4 KB)

Check if column is present and use if-switch accordingly – mlauber71