Opening and reading Zip file
- 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
Hi community,
I am trying to resolve problem with my alteryx workflow regarding to zip files.
First of all, I wanted to open xlsx file from zip but during choosing the exact file I cannot choose the exact sheet (please find screenshot below).
Do you know what could cause this problem?
Thank you in advance for your support.
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you able to upload a copy of the data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is the format for a zipped excel file in the Input Data tool. You can type the fullpath with filename and sheet name in this format in the file path at the top in the Input Data tool.
C:\Users\david\Documents\Alteryx\Testfile.zip|||Testfile.xlsx[Sheet1$]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Unfortunately no
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
When I wrote the full path in the first row it results in such an error:
Do you know why I cannot specify a sheet as normally in xlsx file? Or where can I do this to read some of sheets?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That typically means that the Summary sheet doesn't exist, or is corrupt.
Try this:
Create a new Excel file with some dummy data in a sheet.
Zip it.
Drag the zipped file onto your canvas.
It should create an input data tool that points to your zipped file and you should be able to select the Excel file and then the sheet name, like this:
I've attached the zipped file I used in my example. If this works for you then the problem is not with Alteryx.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You are right, when I am using your test file it works. Do you know what could cause this problem? It is possible that xlsx file with few sheets cannot be read?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Okay, I found the solution. When I deleted all sheets except one, it works on my "Summary" sheet. Thank you for your support!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @MK97pro
I tried a zipped file with multiple sheets and was able to extract them - see attached file.
I would try a couple of things.
1. Manually unzip the file and see if the Input Data tool can load the sheets.
2. Try a different zipping process - I used 7-zip.
