Empty file Handling

[RSA1598789664]

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

[RSA1598789664]

Hi All,

Appreciate if someone could help me on this issue please.

Regards,

Anil

[vikramk]

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.