https://community.qlik.com/t5/Talend-Studio/How-to-Purge-data-using-Talend/m-p/2247892#M32929 <P>hello Every One ..</P> <P>Input :-</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mm.jpg" style="width: 759px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8Vn.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129338i0B390F54AE718054/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8Vn.jpg" alt="0683p000009M8Vn.jpg" /></span></SPAN></P> <P>period_type<span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133049iD780B7DE0116E4D1/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACJ.png" alt="0683p000009MACJ.png" /></span> means Days ,M-Months,Y-years&nbsp;</P> <P>Nb_period:3D- means(3 days Back to Current Date) like this</P> <P>Based On The History Table Delete The Data:-</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nnnd.png" style="width: 344px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8Vs.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148789i11D0F3C05A159830/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8Vs.png" alt="0683p000009M8Vs.png" /></span></SPAN></P> <P>&nbsp;</P> <P>In Talend Job Running Delete The All The Table Data Based on Condtions</P> Sun, 10 Nov 2019 07:34:10 GMT Anonymous 2019-11-10T07:34:10Z https://community.qlik.com/t5/Talend-Studio/How-to-Purge-data-using-Talend/m-p/2247892#M32929 <P>hello Every One ..</P> <P>Input :-</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mm.jpg" style="width: 759px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8Vn.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129338i0B390F54AE718054/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8Vn.jpg" alt="0683p000009M8Vn.jpg" /></span></SPAN></P> <P>period_type<span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133049iD780B7DE0116E4D1/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACJ.png" alt="0683p000009MACJ.png" /></span> means Days ,M-Months,Y-years&nbsp;</P> <P>Nb_period:3D- means(3 days Back to Current Date) like this</P> <P>Based On The History Table Delete The Data:-</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nnnd.png" style="width: 344px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8Vs.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148789i11D0F3C05A159830/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8Vs.png" alt="0683p000009M8Vs.png" /></span></SPAN></P> <P>&nbsp;</P> <P>In Talend Job Running Delete The All The Table Data Based on Condtions</P> Sun, 10 Nov 2019 07:34:10 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Purge-data-using-Talend/m-p/2247892#M32929 Anonymous 2019-11-10T07:34:10Z https://community.qlik.com/t5/Talend-Studio/How-to-Purge-data-using-Talend/m-p/2247893#M32930 <BLOCKQUOTE> <HR /> <A href="https://community.qlik.com/s/profile/0053p000007LOwXAAW">@mahetalend15</A>&nbsp;wrote: <BR /> <P>hello Every One ..</P> <P>Input :-</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mm.jpg" style="width: 759px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8Vn.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129338i0B390F54AE718054/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8Vn.jpg" alt="0683p000009M8Vn.jpg" /></span></SPAN></P> <P>period_type<span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACJ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/133049iD780B7DE0116E4D1/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACJ.png" alt="0683p000009MACJ.png" /></span> means Days ,M-Months,Y-years&nbsp;</P> <P>Nb_period:3D- means(3 days Back to Current Date) like this</P> <P>Based On The History Table Delete The Data <FONT color="#000000"><A href="https://www.mywegmansconnect.us/" target="_self" rel="nofollow noopener noreferrer"><FONT color="#000000">mywegmansconnect</FONT></A></FONT>:-</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nnnd.png" style="width: 344px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8Vs.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148789i11D0F3C05A159830/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M8Vs.png" alt="0683p000009M8Vs.png" /></span></SPAN></P> <P>&nbsp;</P> <P>In Talend Job Running Delete The All The Table Data Based on Condtions</P> <HR /> </BLOCKQUOTE> <P><SPAN>Did you try using a tJDBCRow component?</SPAN></P> Sun, 10 Nov 2019 08:49:47 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Purge-data-using-Talend/m-p/2247893#M32930 Anonymous 2019-11-10T08:49:47Z https://community.qlik.com/t5/Talend-Studio/How-to-Purge-data-using-Talend/m-p/2247894#M32931 <P>This Oracle database Table</P> Sun, 10 Nov 2019 11:50:14 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Purge-data-using-Talend/m-p/2247894#M32931 Anonymous 2019-11-10T11:50:14Z