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.
Solved! Go to 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.
Thank you it worked.