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.
Yes, we can. There are a couple of approaches to this. First, if it's just a one-off and a low number of individual files/sheets then you can simply create a workflow like the below and attached. (The output tools haven't been configured yet as I'm not sure how you want to output them, which is why they show a red exclamation mark).
If you have a lot of files/sheets then I would suggest creating a simple macro to output sheets to files by using their full path as an identifier for individual output files.
I can help with the versioning question. The black and white question mark tool indicates that Alteryx can't find the tool (in this example, my guess is the macro isn't installed)
Try changing the .yxzp extension to .zip, and open it using winzip. Then open each Alteryx workflow or macro in the zip with Notepad or Wordpad, and find the Alteryx version line. It's around the second line of code and looks like this: <AlteryxDocument yxmdVer="2018.1">
Change the version to the version of Alteryx you have. Do this with all of the yxmd and yxmc in the zip. Save the files and update the zip with the new files.
Back in Windows explorer, change the .zip extension back to .yxzp. You can now open and unpack it in Alteryx.
This happens with me on a regular basis, as we haven't upgraded our version in quite a while.
I've attached the files separately for you here. If the question mark is on the Macro icon then it will be because Alteryx didn't import it during the usual unzip process. You will need to add the directory of where the Macro is saved so Alteryx can "see" it. Instructions and more info on Macro installation here.