ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Txt format Import to Alteryx

Jcsh_66
8 - Asteroid

Hi Community,

 

May I know how to import txt. file into the alteryx and how to build the workflow so that alteryx will read the information inside the file. 

 

Kindly refer to the txt file below and i would like to import multiple txt file inside the Alteryx. May i know what the better way to import and how to build the workflow so that the information are captured correctly.

 

 

Jacob_94_1-1615097642498.png

 

 

Emil_Kos
15 - Aurora

Hi @Jcsh_66,

 

this article will show you How to input txt files

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Input-txt-Files-and-Other-File-Type...


Reagrding importing multiple files into alteryx I am assuming they are in the Same folder. If that is the case the easiest way to do it is using wildcard. Please check the article below for few words of guidance:

 

https://www.thedataschool.co.uk/jonathan-sherman/alteryx-importing-multiple-files-at-once/

 

both of them should be really easy to implement😅

 

Jcsh_66
8 - Asteroid

Hi @Emil_Kos ,

 

Is it applicable to txt format as well? As the example given are only xlsx. Do you have any example of workflow that importing the txt file and editing the text file in alteryx?

Emil_Kos
15 - Aurora

Hi @Jcsh_66,

 

This is an example in which I have imported a text file:

this is the configuration that I have used:

Emil_Kos_0-1615364686021.png

 

The output:

Emil_Kos_1-1615364711481.png

This is only for tests but the guide that I found advises to import the data without delimiters and clean the data with the text to columns function afterwards.

 

In your particular example, I think it will take you a while to clean the data in a way that will be useful. 

 

Maybe you can use start importing a function from the input file to minimize the amount of unnecessary data. 


What I would do is I would focus on importing one file properly and after it will work I would come back to the idea of importing all the files at once. 

 

Jcsh_66
8 - Asteroid

Hi @Emil_Kos ,

 

Thanks a lot for the advise. May i know what should i choose for the following options to import the txt file?

Jacob_94_1-1615366728941.png

 

 

 

 

Emil_Kos
15 - Aurora

Hi @Jcsh_66,

 

Change read option to csv file. 

Jcsh_66
8 - Asteroid

Hi @Emil_Kos 

 

It appear the error as shown in the screenshot below. Do you have any idea how to solve it?

 

Jacob_94_0-1615369986392.png

 

Thank you.

Emil_Kos
15 - Aurora

Hi @Jcsh_66,

 

Can you check if you have the same delimiter as in the screen below?

 

Emil_Kos_0-1615370073229.png

 

Jcsh_66
8 - Asteroid

Hi @Emil_Kos 

 

Yes. It is same as per your screenshot. However, i think the error due to i have extra line after 34. Is that possible?

Jacob_94_1-1615370290224.png

 

 

Emil_Kos
15 - Aurora

Hi @Jcsh_66,

 

Please change delimiter to \0

Labels