Knime Conditional Processing

KNIME Analytics Platform
#1

Hi 

I just started working on KNIME and was trying to archieve below with no luck .

I created a database reader and added a filter. I would like to create conditional flow :  If the data we loaded to the reader and filtered is empty (rowcount=0) then do nothing. else if rowcount<>0 send email .

Thanks for help.

Regards

Raf

#2

anyone ?

#3

Hi Raf,

did you take a look into the category Workflow Control -> Switches? These are the nodes you will need.

In your special case you would need the empty table switch and only in case of non empty write. and close this operation with and End If node.

Best regards, Iris 

#4

EDIT1:

I figured it out : assigned email to variable and if rowscount >0 then change variable to proper address email,else do nothing.

Regards,Raf