topic Re: tFileOutputDeliminated creating blank rows in Talend Studio

tFileOutputDeliminated creating blank rows

tYrannoSaurusRex_1 — Wed, 17 Sep 2014 13:52:57 GMT

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.

Re: tFileOutputDeliminated creating blank rows

Anonymous — Wed, 17 Sep 2014 15:05:37 GMT

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.

Re: tFileOutputDeliminated creating blank rows

Anonymous — Wed, 17 Sep 2014 16:10:48 GMT

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

tYrannoSaurusRex_1 — Wed, 17 Sep 2014 16:12:23 GMT

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.

Re: tFileOutputDeliminated creating blank rows

Anonymous — Wed, 17 Sep 2014 16:17:10 GMT

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

Re: tFileOutputDeliminated creating blank rows

tYrannoSaurusRex_1 — Wed, 17 Sep 2014 16:20:15 GMT

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

Talend Open Studio for MDM 5.3.1

Re: tFileOutputDeliminated creating blank rows

Anonymous — Wed, 17 Sep 2014 16:26:56 GMT

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?

Re: tFileOutputDeliminated creating blank rows

Anonymous — Thu, 18 Sep 2014 10:26:31 GMT

Hi GuruGulabKhatri,
Would you mind showing us your actual output result with blank rows?
Best regards
Sabrina