Insert only if the row doesn't Exists

[Anonymous]

Hi,
How can I make it possible to Insert a row only if it doesn't Exists in the table?
I'm using "Update or Insert" on tMySQLOutput component. But that doesn't work for me!

[janhess]

Use Insert.

[Anonymous]

tried that one too.. no luck

[Anonymous]

check out this screenshot!

[janhess]

Screen shot shows Insert or Update. Set it to Insert. Duplicate keys will be rejected.

[Anonymous]

as I mentioned earlier, it still keep inserting records even if i set it to "Insert".
following is the example data:
ID Name SRC
------------------------------------
81687 text1 source
81686 text1 source
81685 text1 source

[Anonymous]

more explaination given in the screenshot below:

[janhess]

In the tMap set the input lookup for inner join and the output to Catch lookup inner join reject to true.

[Anonymous]

thanks but it is still inserting the same records over and over again... Please check out the tMap settings in the screenshot.

[janhess]

You've got nothing in your output key field.