Skip iteration of loop if table is empty

KNIME Analytics Platform
#1

Hi,

I have a csv which I need to search for specific dates, and then the rows of the databse that match these dates are then output to a new csv file just contains these rows.

The problem is that in some cases there are no rows that match the dates, and in this case it creates an empty csv file. Is there a way I can conditionally check if the row filter produces an empty table, and if it does, then break the loop and continue to the next date?

Thanks,

Phillip

#2

Did you see our Switches nodes?

There is the Empty Table switch in which you can define what happens on an empty table and what otherwise. Similar to loops they must be ended with a End If

Cheers, Iris

1 Like
#3

Yeah thanks, I figured out that the Empty Table Switch existed just after posting this, it all works now.

Thanks,

Phillip