TXT File option not available in Input Data drop down menu

Question

Hi Alteryx Community!

I'm facing a simple but frustrating issue. I'm trying to upload a txt file to Alteryx but the .txt file option is not showing up when I use Input Data.

Any idea why this could be happening? The txt file is very large (over 30M KB of data).

Thanks!

geraldo · Answer

@DanielG

select files as csv then change to all types in file browse
select txt file
and set the type of delimiter

DanielG · Answer

@HJ735 -- when you bring in an input tool initially it has .txt listed on there

however that is more of just a filter to the folder that you picked to look in.  Once you pick a .txt file the next pop-up shows this at the top,(image cut up to hide my file address.

Just set it to read as a delimited text file and choose your delimiter

When you do that it gets set up as a CSV in the config window with the chosen delimiter.

Hope this helps

acarter881 · Answer

Hello, @HJ735.

Have you tried the drag-and-drop approach? You can drag the text file onto the Designer canvas and it should give you a window that is shown in the screenshot below. From there, you can specify how to import the data.