Is there a possibility to do an assertion/test

I remember in Alteryx there’s some way to basically do assertions - you can have a workflow where bad values are collected in some table, and connect that with the message node. If the table is non-empty, it would generate a message and make your workflow fail on execution.

Is there a way to accomplish something similar in KNIME? We looked at the breakpoint node, but we were only able to make it generate an error when a table is empty (rather than non-empty), and it also is not very obvious that something broke (it will not create an obvious error dialog etc., mostly a little x on the node).

Thanks!

Hi @ant6n , you could try the Fail in Execution now which is part of the KNIME testing framework extension.

I have used it in the following demo Workflow

Placing the node on one or other branch of an Empty Table Switch would allow the flow to break when a table is not empty, or empty, as required.

2 Likes