Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to make "insert table" wihtout duplicate input data?

Hi,
I load data from table 1 to table 2. And every time I run Talend job, it will insert duplicate data to table 2. How can I make this to throw exception or SQL constraint?
Thanks,
Vincent
Labels (2)
14 Replies
Anonymous
Not applicable
Author

All apologies, you're right, if I check the key column as "Key in update" and "Updatable" it works...
But there is an unecessary update that is done.
Thanks for your help Vaiko and Volker.
But I think that an action on data "Insert if not exists" can be interesting to manage this case and other case when you don't want to update your data.
Anonymous
Not applicable
Author

Hello laurie,
please add a feature request in the BugTracker. Better than "Insert if not exist" would be "Ignore duplicate key error on insert" I think. Your version sound like a (unnecessary) select will be executed before the insert.
Bye
Volker
Anonymous
Not applicable
Author

Hi Volker,
I've already did it : http://www.talendforge.org/bugs/view.php?id=4818
Laurie
Anonymous
Not applicable
Author

This hint below is very useful.
"Shong gave me the hint to look at the advanced tab. Set the option "Use field option" ... "
Took me a couple of hours to work that out.
_AnonymousUser
Specialist III
Specialist III

Hi,
could you please provide the "insert if not exists" functionality also for the tOracleOutput component? (I have also a unique constratint which
give an ORA-... error when someone tries to insert a duplicate...)
That would help a lot as Oracle is the industry standard...
Thanks,
dstefane