This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
At a high level, I think if you pass the filename/path into a Dynamic Input tool, you should be able to properly read the file at runtime, as Alteryx can natively read from Zip files. Unfortunately, I don't have a great example of this, as I don't use Qualtrics, so this is just a theory for now.
Thanks @Jdang1. I was struggling with the responseexports query from Qualtrics with the Content-Type. It works now thanks to your workflow.
I am also able to read the zip file with the dynamic Input tool:
Create a text field containing the Qualtrics output file - however keep a .tmp extension (or something else) because for an unknown reason you can't open the zip file if you chose a .zip file extension in your output file
Create another text field containing the Qualtrics output file and the name of the file you want to unzip in the Qualtrics zip archive (e.g., "C:\Temp\test.tmp|TEST.csv")
Specify the name of the Qualtrics output file in the Download tool instead of using a temporary file
Use the Dynamic Input tool with your field name created in step 2