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.
How about Outputting a Excel file for each Level1, each of which contains a sheet for the Level2 values? That can be done with a single formula and a couple tools. Check out the attached example to see how I use your data to write these outputs to the temp folder.
The trouble with the original request is that Alteryx cannot directly create folders. It can be done, but you'll need to use the Run Command tool to execute mkdir.
In that case, here's a quick example how a Run Command tool can be used to make the necessary directory. It's inside a batch macro so you can update the command argument directly without having to write a .bat file first and then run that.
The Block Until Done tool is handy for making sure the Run Command is ran first before the Output attempts to put any files in the folder.
Thanks for the quick reply, this makes sense. But I am using alteryx 22.214.171.124055. So, except for the run command part, I can see everything, only that tool is showing as a Question mark. If it's not too much to ask, can you just show what did you write inside the run command tool, so I can copy and paste in this?
That's odd because there should be no difference in anything I built between our versions. Do you know how to edit the version in the XML text of the workflow? Sometimes that works better than letting Designer overthinking it.
Anyways, here's the contents of the MkDir.yxmc batch macro:
The arguments only works if you edit the name (not label!) of the Control Parameter tool to "Folder". This was it can be directly referenced in the argument.
/c md "%Question.ControlParam.Folder%"
The Text Input and %temp% output of the Run Command tool has no affect on the make directory process and are only there to satisfy the connection requirements of the Run Command tool.