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

Highlighted
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.PNGInput data in date formatiInput 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.

Highlighted
Moderator

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
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
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.

Highlighted
Moderator

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
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
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.
Highlighted
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.

Highlighted
Moderator

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
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Sixteen Stars
Sixteen Stars

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

Create a new one


TRF

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog