How to test if a node port output is empty, if not throw error

KNIME Analytics Platform
1

I’m looking for a way for KNIME to alert me if a node output port has records rather than empty. For example, in a joiner it’s possible that new values will appear in the data, and I want my workflow to alert me in case I have unmatched data in the join.

What node can I use to attach to port1 or port2 in a Joiner to check if record count != 0?

In Alteryx this is trivial using the Test tool, which I can configure to throw a red workflow-stopping error if there are unmatched records in the join, see image below. How do I replicate this in KNIME please?

test tool
test tool1381×671 35.9 KB

The reason I want to be alerted to unjoined data is so that I can then update the join file, perhaps because new or unanticipated categories have appeared in the source data which weren’t present when the workflow was designed. It’s therefore good practice to alert the user rather than continue on but ‘losing’ the unmatched data, if that makes sense.

2

Hi !
Perhaps empty table switch will be useful ? Empty Table Switch – KNIME Community Hub

1 Like
3

Thanks @JPollet - how would I then raise some kind of event, flag or warning to alert me? I’d like something loud and obvious, rather than a subtle message that might get missed in the Console. Thanks

4

I don’t really know. You can halt the process with the breakpoint node.
Best regards,
Joel

2 Likes
5

Like this (rowid stand for the further processings) :
breakpoint.knwf (15,1 Ko)

2 Likes
6

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