How to INSERT IGNORE with Write Database operator....?
Hi all. I'm using a Write Database operator to append rows to a MySQL table. I have a unique index consisting of 2 columns in the destination table. When my exampleset contains a row with a pair of values that already exists in the table, the Write Database errors and halts. I would like the operator to ignore such errors and continue to append all the rows where the pair of these values DON'T already exist in the table (i.e. to behave like a INSERT IGNORE statement).
How can I run this operator so it would ignore such errors and only append "new" pairs of values?
Thanks in advance for any suggestions,