output TXT

[DennyChan]

Hello

how can you output and file as a .txt doc

many thanks

denny
 

[CristonS · Accepted solution]

Hi Denny,
In an Output tool, select Comma-Delimited Text Files (*.csv) as your File Format.  When naming your file to save, add the .txt extension.



Thanks,
Criston

[DennyChan]

Thanks Criston for your help

It worked but however I need the delimated as a tab is there a way to have the Tab formatting and output as .txt

many thanks

Denny

[AdamR_AYX · Accepted solution]

Hi Denny

For the Delimiters option in the output tool enter \t

This will make the file tab delimited

Cheers
Adam

[DennyChan · Accepted solution]

Thanks Adam and Criston

It worked, much appreciated, thanks for your Time

Denny

 

[aMac]

Hi Criston, thanks for the tip. It seems like this approach is no longer working in the later releases. I even tried creating a filename variable that was  [variable] + ".txt" and then using that as the filename variable but the workflow still error'ed out  and files that were outputted were exported as csvs

Is there a new recommended approach?

EDIT: After some continual tinkering around I was able to resolve this specific problem but:

1. Un-checking the 'first row contains headers' checkbox

2. setting 'Quote Output fields' to Never

3. Deleting the delimiter null and keeping it as null

4. Setting the generic field output to .txt

I am not sure if @CristonS's image showed all this, but it's currently broken for me, so hopefully other users find this checklist helpful

[craigmewis]

Thanks a lot for this! It works for me.

[ColinG]

Replying to this old thread since this was a high result in Google when trying to find a solution to my problem of writing a relatively raw text file in Alteryx, because of the text output tool limitations that have wasted so much of my time.

I'm going to switch to trying to write the file with Python tool instead of native Alteryx output tools.

aMac's method isn't working for me in 2021.4.2. I tried entering a literal "null" for delimiter and it said it must be one character. If I delete the "," and leave that field blank, then it doesn't write delimiters on the first row of data. On the 2nd row of data it doesn't actually write the data, but it thinks it's writing data and puts in a bunch of commas (which it was explicitly configured not to do) to delimit what it incorrectly thinks are blank columns.