Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Reading .txt file from .zip file

Pravallika20
8 - Asteroid
‎01-27-2022 06:58 AM

HI everyone,

 

I am trying to pull the .txt file delimited with '|'. from the zip file but I am unable to do it. Can anyone please suggest me how to get this

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

4 REPLIES 4
gabrielvilella
14 - Magnetar
‎01-27-2022 09:52 AM

Hi @Pravallika20, just drag and drop the zip file into Alteryx. It should pop up a new window asking to select the file name and how to parse that file. Select CSV.

gabrielvilella_0-1643305900555.png

Then on the input data tool change the delimiter to |, it's on line 9.

gabrielvilella_1-1643305963235.png

 

Reply
Pravallika20
8 - Asteroid
‎01-27-2022 10:57 PM

Hi @gabrielvilella ,

 

This worked for me. Thanks

Reply
Pravallika20
8 - Asteroid
‎01-28-2022 03:09 AM

Hi @gabrielvilella ,

 

When I was trying to pull the text file from the zip folder which is present inside the 2 subfolders, I was unable to access it. Can u pls help me in this one?

Reply
gabrielvilella
14 - Magnetar
‎01-28-2022 05:12 AM

Hi @Pravallika20, if you have multiple folders within the zip it is going to show you all those folder when you drag the file into Alteryx. 

Reply
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All