Compressed Files

[furyan23]

Hello, 

I have the attached file which I am trying to open using dynamic input however due to the file being a compressed zip file it fails.  I believe part of the issue maybe due to the file name is longer than needed.  Has anyone encountered such an issue and if so do you have a solution?  

thank you in advance. 

[Felipe_Ribeir0 · Accepted solution]

Hi @furyan23 

your guess is correct, this full filename  + directory hierarchy is beyond what dynamic input can handle.

 One way of dealing with this situation is by unziping the file before trying to import it. I used this macro to do it: https://community.alteryx.com/t5/Community-Gallery/Unzip-zip-and-yxzp-files/ta-p/1161434. Take a look at the attached workflow.

[furyan23]

Thank you it worked.