topic tFileOutputDelimited "don't create empty file" on but file created in Talend Studio

tFileOutputDelimited "don't create empty file" on but file created

Anonymous — Sat, 16 Nov 2024 13:17:42 GMT

Hello,
empty files are created although "don't create empty file" is checked on tFileOutputDelimited 😞
Am I missing something ?
Regards,
Didier

Re: tFileOutputDelimited "don't create empty file" on but file created

Anonymous — Sat, 11 Sep 2010 08:41:29 GMT

In fact, the file contains a line break. It means if input an empty value (empty string or null), it output an empty line to the file.
Perhaps you could report it to bug tracker.
Thanks

Re: tFileOutputDelimited "don't create empty file" on but file created

Anonymous — Wed, 22 May 2019 10:48:10 GMT

Hi All,

even i m getting this empty file issue, even though there's no data in my output file.

Can any1 pls reply on this.

Re: tFileOutputDelimited "don't create empty file" on but file created

Swechchha — Fri, 25 Jun 2021 07:37:54 GMT

I have similar job where i ticked the On Empty Delete option in tFileOutputDelinited.

After running this job, When I check the folder, all the files were showing even the empty ones, but when I refreshed the file explorer, all 0 byte files were gone. So try refreshing once.

Secondly, If I am using a tMap to split/filter output into many files and few of my files are going to be empty. Suppose I am also copying the generated files with tFileCopy to another location. In such case, these 0 byte files will not be deleted from destination (where you have copied the files). On hit and trial, It looks like tMap routes data into mupliple flows almost at same time, so folder might not be refreshed on time to delete empty files.

So, in such case make sure to copy files on destination only using tPostJob or OnSubJobOK.