I have a KNIME workflow that produces 5 tables that may or may not contain data. The tables that contain data represent inconsistencies that need to be analyzed. The empty table indicates that there are no inconsistencies in that process. I would like to generate an Excel file containing the positions of these tables. Processes with inconsistencies and those without any issues are considered OK.
I used the “Empty Table Switch” node to direct the flow either to continue and generate the table with inconsistencies or to generate a message saying “No data to analyze.” I used a Table Creator to create the message.
Example of a filtered table
I would appreciate suggestions on whether I’m doing the right thing or if there’s a better, smarter way to do this.
@Aldemir for switches and case nodes you would have to define an alternative path and you would have to close the construct if you want to continue like in these examples. They mix different sources like python or Sql but the functions are the same how to configure switches.