Empty table input for Database Writer

Hi everyone,

I am currently trying to execute a Database Writer before a Database Reader in my workflow using flow variable ports.

This works fine usually, but sometimes the input table (it's imported from a manually edited Excel file using Excel Reader) for the Database Writer node is empty. This causes the Writer node to display an error ("no columns in input data"), and the Reader node won't execute. The problem does not occur when the flow variable connection is removed.

Is there any way to circumvent this? E.g. changing the Database Writer to not throw an error when there is no input table, or modifying the Excel Reader to give a default output in case of an empty table?

I would be very thankful for any suggestions.

 

Hi MadF,

You can use the empty table switch after the Excel Reader to solve that issue.

Best,

Jon