https://community.qlik.com/t5/Talend-Studio/How-to-delete-rows-from-an-oracle-table/m-p/2366018#M129554 <P>Hi, I need to delete rows from an Oracle table based on the column values, for example registration_year &lt; 2020 and status not=sold. Could you please let me know which component to use.</P><P></P><P></P> Mon, 13 Sep 2021 02:19:36 GMT stan1609735726 2021-09-13T02:19:36Z https://community.qlik.com/t5/Talend-Studio/How-to-delete-rows-from-an-oracle-table/m-p/2366018#M129554 <P>Hi, I need to delete rows from an Oracle table based on the column values, for example registration_year &lt; 2020 and status not=sold. Could you please let me know which component to use.</P><P></P><P></P> Mon, 13 Sep 2021 02:19:36 GMT https://community.qlik.com/t5/Talend-Studio/How-to-delete-rows-from-an-oracle-table/m-p/2366018#M129554 stan1609735726 2021-09-13T02:19:36Z https://community.qlik.com/t5/Talend-Studio/How-to-delete-rows-from-an-oracle-table/m-p/2366019#M129555 <P>Hi </P><P>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. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 13 Sep 2021 02:25:46 GMT https://community.qlik.com/t5/Talend-Studio/How-to-delete-rows-from-an-oracle-table/m-p/2366019#M129555 Anonymous 2021-09-13T02:25:46Z