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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Delete the empty last row in tfileoutputdelimted

Hi,
I am writing a line by line using tFileoutputdelimited. In row separator i can specify the line feed i.e '\n'. It's working good to write the file upto the N-1 record. My problem is, I don't want an empty line after the last record.
Example
2 records write into a file that contains 3 lines. the last line is an empty.  the reason is due to row separator '\n'.
I don't want the empty line in my file. If the record is 10 then the file line is also 10 only.
Is there any skip empty row option in fileoutputdelimted?
Thanks in advance
0683p000009MCev.jpg 
Labels (2)
2 Replies
Anonymous
Not applicable
Author

If you read the file (tFileInputDelimited) just after completing your writing, the line count should be correct (2 rows, and no 3). 
Equally, if you put a tJava with System.out.println(((Integer)globalMap.get("tFileOutputDelimited_2_NB_LINE")));  you will have the right amount of lines.
 I don't think that the final "\n"  would cause any problem with the counting.
Anonymous
Not applicable
Author

Did you find the solution to the problem? I am tempting the same problem.