Alteryx Designer Desktop Discussions

SH_94 · ‎03-06-2021

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.

Emil_Kos · ‎03-06-2021

Hi @SH_94,

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😅

SH_94 · ‎03-10-2021

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 · ‎03-10-2021

Hi @SH_94,

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

this is the configuration that I have used:

The output:

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.