Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

how do i input a .dat file to alteryx?

Nam_Am
5 - Atom

I am trying to import a .dat file to Alteryx using the input tool, however i am not sure what "File format" to use when i input it. Any leads would be helpful.

2 REPLIES 2
jirikrecek
8 - Asteroid

DAT files do not have a unified structure like TXT or CSV. 
In order to be able to open it, you should first know what application created it and how it is formatted. This is hard to answer without knowing more about your file.
Alteryx doesn't have a default .DAT read capability for the above reasons.
If it is comma delimited or tab delimited text inside it, you may configure to read as a CSV or a tab delimited file and actually get it to open, but it all depends on how your DAT file is actually structured.
What app/system did you get this file out of?

Luke_C
17 - Castor
17 - Castor

Hi @Nam_Am 

 

Agree with @jirikrecek. I've had success reading them in as a text/csv file with no delimiter (\0) and increasing the field length and parsing further in the workflow. But it all will depend on how the data is set-up in the file. If you open it with notepad you should be able to get a good sense of it. Here's an example:

image.png 

Labels
Top Solution Authors