how do i input a .dat file to alteryx?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
