Stop workflow if column contain missing value

[Yu_C]

Hi

I would like KNIME to stop the workflow if missing value is found in a mandatory column after joiner node.

How can I make this possible?

Stopifmissingvalue.knwf (25.8 KB)

[MartinDDDD]

Hey there,

here is one way to handle that:

• send matching and left unmatched rows to different ports of joiner node (matching top, left unmatched, middle)
• Set up empty table switch for middle port => if no unmatched => all good, else trigger e.g. break point
  Overview
  
  

Workflow:

Stopifmissingvalue.knwf (85.9 KB)

[Yu_C]

That is a good way thank you! I did not learn of empty table switch !
I will try this thank you very much

[MartinDDDD]

You are welcome!

I highly recommend everyone who wants to learn more slightly advanced features to take the time and watch this playlist from KNIME on youtube:

Also if this solved your question, please flag as solution - the next person coming across this topic searching for help will much appreciated it