How to start the process based on the data available in excel

[Darmesh]

Hi,

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 runInput data in date formati

2. If there is data and then process will start. and after the process is completed, I want to empty the input excel.

How to do this in Talend.

[manodwhb]

@Darmesh, you need to take two flows as shown in below.

[Darmesh]

If my input excel does not have any data. it should not go to the next process.

it is going to the next process and throwing null pointer error

How to the 2nd steps. (i.e) automatically delete the data after the process is completed.

[manodwhb]

@Darmesh,insted of >= can you use > in run if condition and let me know?

[Darmesh]

Yes. That is working fine. But can you tell me how to empty the data in a
file after the load is completed.

[Darmesh]

@manodwhb @TRF

Can you help me on this.

how to empty the data in a file after the load is completed.

[manodwhb]

@Darmesh,you can move the to archive in tPost job using tFileArchive.

[TRF]

Create a new one