PO attachments download using Alteryx

Question

I have made this workflow to extract PO documents using the table of EKKO, SRGBTBREL and SOOD. However, i need to extract data for multiple PO numbers and i want output in such a way that it creates folder and should be based on PO number. The numbering should happen dynamically. Example to extract data for Po numbers 1001,1002,1003 and 1004.

I need the workflow to make folder of 1001 and save all the attachments in 1001 folder similarly create folder for 1002 save all its attachments and so on.

Also, I have used the screenshot of the workflow i have used to extract PO documents from table EKKO using DVW and Alteryx.

Any help on this would be appreciated.

Screenshot.png

ayushalter234 · Answer

I am actually a beginner in Alteryx and it would he helpful if you could help how can i incorporate the run command tool or python in this workflow since i specify the path in the blob output tool.

jrlindem · Answer

For the dynamic creation of folders that your output would be written into, you'll need to consider using the Run Command tool (or Python).  This way you can pass the desired directory string into that tool (with additional configuration) and have it check for, and ultimately create if missing, the directory that you want.  Then you use that same directory path in the rest of your workflow along with the file name to use in your output tool.

I can try and mock something up for you if needed, but I think that should get you started.  -Jay