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.
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.
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.