topic Re: Empty file Handling in Talend Studio

Empty file Handling

RSA1598789664 — Sat, 16 Nov 2024 01:27:55 GMT

Hello,

Could some one please help me on the below requirement.

Requirement

I need to download the file from shared location and copy to local directory. (This is done now)

Once the file is being copied to local directory , Check if file is empty if yes then enter data in error log file

Local directory has all types of files in it (.csv, .txt, .xlsx etc )

Can someone advice me the flow of the job (Copying files from local directory and creating error log file)

Best regards,

Anil Rawat

Re: Empty file Handling

RSA1598789664 — Thu, 17 Sep 2020 09:45:40 GMT

Hi All,

Appreciate if someone could help me on this issue please.

Regards,

Anil

Re: Empty file Handling

vikramk — Thu, 17 Sep 2020 10:13:41 GMT

Hi RSA1598789664,

Once the file is copied to local directory, you can read the file in same job and and find the count of records using global variables. if no of records is equal to zero then you can create logs using error handling components. Below is job flow:

shared location->local directory->fileinput component->tlogrow (or) tfilerowcount using global variable

let me know if you need help further.