topic Re: Zero rows being written to output file in Talend Studio

Zero rows being written to output file

JM39 — Sat, 16 Nov 2024 00:00:03 GMT

Hi everyone

I have an issue where I have an excel input file with 6345 rows.

I created a tmap to map all the source columns into the same columns in a target file

Output should be a delimited file (.csv)

BUT, when I run the job it shows that 6345 rows are going into the output & it creates an output file but the output file is empty, i.e. no data

I've attached some screenshots of my job. Is anyone able to help?

Re: Zero rows being written to output file

gjeremy1617088143 — Tue, 29 Jun 2021 14:53:26 GMT

HI, does the file already exist on the folder when you write it ?

If you use a tLogRow instead of tFileOutputDelimited, do you see the data in the console ?

Have you check Don't generate empty file in the Advanced settings of the TFileOutputDelimited ?

Send me Love and Kudos

Re: Zero rows being written to output file

JM39 — Tue, 29 Jun 2021 14:55:55 GMT

Hi No but I've got it set to overwrite if it already exists anyway.

I think I figured it out though. I think it was a memory/storage issue on the location I was trying to write the file to. I've deleted some large files, tried it again and it seems to be running fine now!

Re: Zero rows being written to output file

gjeremy1617088143 — Tue, 29 Jun 2021 14:58:20 GMT

Yes if you do'nt have enough space on the target location you can't write data.