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!

[Anonymous]

key_strings is the output component having row12.keywords. it has a value.

[janhess]

OK so your output is all the records that don't match the lookup.

[Anonymous]

it's fixed. I had to use the Global Variable.

[janhess]

what Global Variable? You never mentioned it.

[_AnonymousUser]

Set it to insert. Press the button repeatedly will be rejected.

[Anonymous]

@janhess > I meant the GlobalKey Map variable.
By the way: i'm having the same thing as @infoleather mentioned. rows are rejected when I run the job for second or third time. But for the first time, it is inserting everything... that means duplication is still there!

[janhess]

Sorry, don't understand what you're doing.

[Anonymous]

this is strange, i've provided all the details above.
Well.. I've just taken some screenshots of the entire job workflow including the queries and the mysql results. hope that helps in understanding!

[janhess]

Don't understand the query in image 3. What are the globalMap.Get items?
The table you are looking for duplicates in is keyed on an id so you would need to look for duplicate data items.

[Anonymous]

globalMap.Get items are setup in tMap so can be used in the Query, to find the exact match.
don't get what you mean?
"The table you are looking for duplicates in is keyed on an id so you would need to look for duplicate data items."
please be descriptive!