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. 

ABC DEF AR TRANSACTIONS_63050_2023-5-25_23h31m11s.zip

Felipe_Ribeir0

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.

WF_UNZIP_FILES.yxzp