Text file output from workflow having blank row

[saisrinu]

Hi all,

I have built a workflow which will save output in a text file which will then be picked up by another application. 

I am using Output tool configured as : file format - CSV, Delimiters - \t, Quote output Fields - Auto, Code Page - ISO8859-1 Latin I, Line ending style - Windows and Write BOM checked.

The output text file is having last line as blank due to which File cant be picked up by application. can you help me how to make sure that last line doesnt come to be blank.

Thanks in advance,

Srinu.

[Qiu]

@saisrinu 
Followed your setting and tested on Output Sample.

The results are just alright.

Any possiblities that data stream into output tool is having the blank line?

[saisrinu]

Hi Qiu, Thanks for the response. 

No input data dont have a blank row. 

I see your output file is csv, I want it to be .txt.

[Greg_Murray]

I found a workaround for you to try. If you covert to blob and output with the blob tool you don't get the extra line at the end. It's a little trickier to delimit by tabs this way, but the attached workflow worked for me.

Here is another discussion with a similar issue.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-add-a-tab-in-the-middle-of-a-te... 

Hope that helps,

Greg

[saisrinu]

Hi Greg - thanks for your response. I have tried to use this in my workflow but it didnt work. 
The workflow I have has multiple sources and I am preparing them to have common columns and then looking to output. 

i am attaching a sample workflow with a dummy input which is in a format of the final table in my workflow. I would want to have this in .txt with no last row as blank.

Thanks,

Srinu.

[Greg_Murray]

@saisrinu,

In order for this method to work, you need to format the output into a single field like I had in the workflow in my last comment. Here is aanother example workflow using your sample data.