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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
stan1609735726
Contributor II
Contributor II

How to delete rows from an oracle table

Hi, I need to delete rows from an Oracle table based on the column values, for example registration_year < 2020 and status not=sold. Could you please let me know which component to use.

Labels (2)
1 Reply
Anonymous
Not applicable

Hi

You can use tOracleOutput component and select the table action 'Delete' to delete the rows, before tOracleOutput, use tFilterRow to filter the rows that matches the condition you set.

 

Regards

Shong