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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
AYAHIAOUI1629282039
Contributor
Contributor

update data base with auto increment key

hello guys

iwant to update table with auto increment key when i chose insert or update i have error you must have a key

Labels (2)
11 Replies
gjeremy1617088143

Ok so if you have the primary key on both you could set it on the output schema

And you use insert or update in the tdboutput. Maybe you have to desactivate auto increment in postgre table before if you want to preserve the id of oracle table for The insert. You could execute raw sql in tDBrow component

AYAHIAOUI1629282039
Contributor
Contributor
Author

no i didnt import oracle id