tFileOutputDeliminated creating blank rows

tFileOutputDeliminated creating blank rows

Hi,
I am using a tFileOutputDeliminated to get output in text file. I am using row separator as "\n". The issue is, I want to activate the Append option. But then after running job various times, blank rows appear where data from every run ends.
Is there any way to remove these blank rows? either from tFileOutputDeliminated where it doesn't generate those rows or by use of some other component.
Five Stars

Re: tFileOutputDeliminated creating blank rows

I've never seen this issue unless there are blank rows in the input.
Where is the data coming from? tFileInputDelimited, for example, has the option to "Skip empty rows".
There's lots of ways to filter out "empty" rows depending on where the data comes from.
I wouldn't think your issue is due to appending.
Seventeen Stars

Re: tFileOutputDeliminated creating blank rows

hi,
can you write data in different files (without append option) without blank lines ?
as tal00000 has suggested, check sources if contains empty rows.
regards
laurent

Re: tFileOutputDeliminated creating blank rows

hi tal00000,
As mentioned in my question, I have kept Append option active, thus whenever I run the job, the last row creates new line. So when new set of data is inserted, it leaves blank row between last row of previous data set and first row of new data set.
I want to avoid this.
Source doesn't  have blanks.
Seventeen Stars

Re: tFileOutputDeliminated creating blank rows

check whitespace at the end of your files ?
which version of Talend are you using ?

Re: tFileOutputDeliminated creating blank rows

check whitespace at the end of your files ?
which version of Talend are you using ?

Talend Open Studio for MDM 5.3.1
Seventeen Stars

Re: tFileOutputDeliminated creating blank rows

i've generated some data and append in cvs.
Cannot reproduce your problem.

I guess there an "extra line" in your data source at the end of file.
What is the filed seperator in your file?
Moderator

Re: tFileOutputDeliminated creating blank rows

Hi GuruGulabKhatri,
Would you mind showing us your actual output result with blank rows?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.