I'm not 100% sure what the problem is, but the "Update Database" operator works the following: You have an example set with exactly the same columns as your database table. Then you select one or more ID columns via the "attribute filter" parameters. These are the columns (and values) which will form the WHERE clause in the UPDATE statement. ALL other columns are then used for the SET clause. If the WHERE clause returns 0 rows, the UPDATE statement will be changed to an INSERT.
_________________________________________________________ Team Lead Software Engineering | RapidMiner GmbH