Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Generate Don't empty file

Hello,

I'm doing a load file by tFileOutputDelimited component. I do not want an empty file is generated. To do this, I have marked the option Generate Don't empty file. When there is no information to load and execute the process generates a file with me 0Kb. This causes me many problems. Is there any way to fix it?


Thank you very much.
Greetings.

Labels (2)
13 Replies
Anonymous
Not applicable

Hi,
What does your job design look like? What's the error message you are getting?
More information will be preferred.
Best regards
Sabrina
Anonymous
Not applicable

There is no error. The problem is that generates a vacuum 0Kb file when it should not generate anything.
Anonymous
Not applicable

0683p000009MFuP.png
vapukov
Master II
Master II

All work as expected,
when "Don't generate empty files" checked - no files will be created
if not - need more information, version, Job screenshots, settings and etc
Anonymous
Not applicable

0683p000009MFuU.png 0683p000009MFhg.png 0683p000009MFhg.png


In the tmap1 you can see, I have filters to generate files if the conditions are met. Still, although the conditions are not met, the empty file is generated with the check marked.
vapukov
Master II
Master II

I just can confirm - I do absolutely the same
no files in output folder
only one idea - I was long time ago have problem, when Talend can not delete files under windows, but it was return error
check Java version, test on other machine

0683p000009MFuZ.png
cristianmarino
Contributor
Contributor

Hi.

I also have the same problem with version "7.3.1",

how can i solve?

thanks

Cristian

Anonymous
Not applicable

Hello,

Could you please give us more information about the issue you are facing when checked out "Generate Don't empty file" option in tfileoutputdelimited component?

Best regards

Sabrina

Swechchha
Contributor
Contributor

I have similar job using tMap to create files based on a condition.

Only one out of many files need to be created at a time. Rest will be empty so should be deleted. So i tick the On Empty Delete option.

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

Secondly, If I copy the files with tFileCopy to another location before the job ends, these 0 byte files will not be deleted from destination.

So, in such case make sure to copy files only after tPostJob, so that all the tMap flows are processed first and then files are deleted at source if they are 0 byte, then when job ends(tPostJob) it copies files at your destination.