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

Six Stars

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

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 runa.PNGb.PNGInput 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.

Thirteen Stars

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

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

Untitled.png

Manohar B
Six Stars

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

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 errora.PNGb.PNGc.PNG

 

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

Thirteen Stars

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

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

Manohar B
Six Stars

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

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

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

@manodwhb @TRF

 

Can you help me on this.

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

Thirteen Stars

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

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

Manohar B
Forteen Stars TRF
Forteen Stars

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

Create a new one


TRF