Hello KNIME community - I’m looking to learn about skipping loop execution.
I am reading a “parent” google sheet and extracting a “child” google sheet ID that is in each row. I pass the child google sheet ID as a variable into another Google Reader node. I want to read the “ABC” tab, if it exists, on every child sheet passed in.
However, not all child sheets have an “ABC” tab, and this is stopping further execution. I’d like to just go on to the next child link from the parent sheet. Please help with ideas to get around this.
You can make use of Error Handling nodes in KNIME to prevent workflow failure.
Here, you can put Google sheet reader inside a try-catch construct and pass an empty table in case of failure. You just need to let the Loop End allow different table specifications in each iteration or make sure that you pass the same table structure instead of an empty table.