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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Unable to exclude Additional Columns in tOracleOutput update

Is there anyway to exclude the Additional Column in an update using tOracleOutput?
I am generating an additional column key using an Oracle sequence.
However after noticing some updates were failing I noticed that the generated update statement was trying to update the "additional column" (see below). Is there any way to exclude the additional column when using field options?
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try adding the column to the schema. Then in the Additional columns section select the new column as the Reference and set the position to replace.

View solution in original post

4 Replies
Anonymous
Not applicable
Author

*bump*
Anonymous
Not applicable
Author

Customers component image:
Anonymous
Not applicable
Author

Try adding the column to the schema. Then in the Additional columns section select the new column as the Reference and set the position to replace.
Anonymous
Not applicable
Author

Thanks that works!