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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tYrannoSaurusRex_1
Contributor III
Contributor III

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.
Labels (2)
7 Replies
Anonymous
Not applicable

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.
Anonymous
Not applicable

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
tYrannoSaurusRex_1
Contributor III
Contributor III
Author

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.
Anonymous
Not applicable

check whitespace at the end of your files ?
which version of Talend are you using ?
tYrannoSaurusRex_1
Contributor III
Contributor III
Author

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

Talend Open Studio for MDM 5.3.1
Anonymous
Not applicable

i've generated some data and append in cvs.
Cannot reproduce your problem.
0683p000009MAwg.png 0683p000009MAsH.png
I guess there an "extra line" in your data source at the end of file.
What is the filed seperator in your file?
Anonymous
Not applicable

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