An example of combining SQL database, loop and case switch

An example of combining SQL database, loop and case switch
there are 10 chunks in the database. some of them have fault=1 lines some do not. The chunks with faulty lines should be handled differently and get a separate export to Excel
https://forum.knime.com/t/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/61127/10?u=mlauber71

External resources

• A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
• KNIME and Java - simple if then else - with some string conversion
• Check if column is present and use if-switch accordingly
• META: A meta collection about Loops, Switches, Paths and Flow Variables in KNIME (and some ZIP files)
• HUB: An example of combining SQL database, loop and case switch
• forum entry