topic Re: How to start the process based on the data available in excel in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312072#M83054 Yes. That is working fine. But can you tell me how to empty the data in a<BR />file after the load is completed.<BR /> Mon, 25 Jun 2018 14:34:14 GMT Darmesh 2018-06-25T14:34:14Z How to start the process based on the data available in excel https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312068#M83050 <P>Hi,</P> <P>1. I want to start the process if there a data in the excel sheet. If there is no data in excel then the process should not run<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="a.PNG" style="width: 539px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyC2.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144850i9CF53483478F48F5/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyC2.png" alt="0683p000009LyC2.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Input data in date formati" style="width: 281px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyC7.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130260i5E9F10975EB6A5F2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyC7.png" alt="0683p000009LyC7.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Input data in date formati</SPAN></SPAN></P> <P>2. If there is data and then process will start. and after the process is completed, I want to empty the input excel.</P> <P>How to do this in Talend.</P> Mon, 25 Jun 2018 06:22:43 GMT https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312068#M83050 Darmesh 2018-06-25T06:22:43Z Re: How to start the process based on the data available in excel https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312069#M83051 <P><A href="https://community.qlik.com/s/profile/0053p000007LMabAAG">@Darmesh</A>, you need to take two flows&nbsp;as shown in below.</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 787px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly8u.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147584i0A714626BBC48096/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly8u.png" alt="0683p000009Ly8u.png" /></span></SPAN></P> Mon, 25 Jun 2018 06:30:24 GMT https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312069#M83051 manodwhb 2018-06-25T06:30:24Z Re: How to start the process based on the data available in excel https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312070#M83052 <P>If my input excel does not have any data. it should not go to the next process.</P> <P>it is going to the next process and throwing null pointer error<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="a.PNG" style="width: 859px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyCH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143662iF16BE39BB39D92FE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyCH.png" alt="0683p000009LyCH.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="b.PNG" style="width: 571px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyCM.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129143iB2D7D68158607D08/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyCM.png" alt="0683p000009LyCM.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="c.PNG" style="width: 404px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyCW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132431iA1A41304849AC5CA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyCW.png" alt="0683p000009LyCW.png" /></span></SPAN></P> <P>&nbsp;</P> <P>How to the 2nd steps. (i.e) automatically delete the data after the process is completed.</P> Mon, 25 Jun 2018 07:11:59 GMT https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312070#M83052 Darmesh 2018-06-25T07:11:59Z Re: How to start the process based on the data available in excel https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312071#M83053 <P><A href="https://community.qlik.com/s/profile/0053p000007LMabAAG">@Darmesh</A>,insted of &gt;= can you use &gt; in run if condition and let me know?</P> Mon, 25 Jun 2018 07:46:04 GMT https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312071#M83053 manodwhb 2018-06-25T07:46:04Z Re: How to start the process based on the data available in excel https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312072#M83054 Yes. That is working fine. But can you tell me how to empty the data in a<BR />file after the load is completed.<BR /> Mon, 25 Jun 2018 14:34:14 GMT https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312072#M83054 Darmesh 2018-06-25T14:34:14Z Re: How to start the process based on the data available in excel https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312073#M83055 <P><A href="https://community.qlik.com/s/profile/0053p000007LKmJAAW">@manodwhb</A>&nbsp;<A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A></P> <P>&nbsp;</P> <P>Can you help me on this.</P> <P><SPAN>how to empty the data in a&nbsp;</SPAN><SPAN>file after the load is completed.</SPAN></P> Wed, 27 Jun 2018 11:28:45 GMT https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312073#M83055 Darmesh 2018-06-27T11:28:45Z Re: How to start the process based on the data available in excel https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312074#M83056 <P><A href="https://community.qlik.com/s/profile/0053p000007LMabAAG">@Darmesh</A>,you can move the to archive in tPost job using tFileArchive.</P> Wed, 27 Jun 2018 11:31:49 GMT https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312074#M83056 manodwhb 2018-06-27T11:31:49Z Re: How to start the process based on the data available in excel https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312075#M83057 <P>Create a new one</P> Wed, 27 Jun 2018 11:31:55 GMT https://community.qlik.com/t5/Talend-Studio/How-to-start-the-process-based-on-the-data-available-in-excel/m-p/2312075#M83057 TRF 2018-06-27T11:31:55Z