Text file output from workflow having blank row

Question

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

Greg_Murray · Answer

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

text output.yxmd

saisrinu · Answer

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.

New Workflow2.yxmd

Book1.xlsx

Greg_Murray · Answer

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-text-in-a-cell/td-p/655978

Hope that helps,

Greg

text output.yxmd