I am using the DB Table Writer component to copy some tables in our data base. It works great, but I would like to set the option if table exists (Overwrite, Append, Fail) with a flow variable. I’ve tried to set a string with the words “Overwrite”, “Append”, but I receive the following errors:
ERROR DB Connection Table Writer 3:3 Execute failed: No enum constant org.knime.database.node.connector.tablewriter.DBConnectorTableWriterExistingTableOption.Append
ERROR DB Connection Table Writer 3:3 Execute failed: No enum constant org.knime.database.node.connector.tablewriter.DBConnectorTableWriterExistingTableOption.Overwrite
Can someone help me to understand what values the variable should be to trigger the respective action?