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.
I have a workflow that takes in .csv files, formats them, and then outputs them as rendered Excel files (with differing tab names depending on invoice numbers) or as PDF files. I have them all going to a local folder on my computer and I like to spot check them, then they all have to go into different folders based on the filename. I have about 200 different folders that they could go to, and I do not want to add about 200 extra render tools to my already huge workflow.
is there a simple way that I can copy (or move) those files from the local folder so that they go to their correct final destination?
I do not know how to attach an input for this. let me see if I can explain it better.
My workflow that formats and fixes my files is huge, it has 13 different render outputs that all drop into the same folder on my desktop.
The files that it creates are .pdf or .xlsx files, and the .xlsx files may have one or multiple tabs, and those tabs are all named based on invoice numbers in the above workflow. These are my inputs.
I like having them all dump into one folder so I can spot check them, then I have an auto-emailer that sends them out to the customers from that one folder. After Alteryx emails them, I have to go in and drag and drop them into their respective folders on my computer, and generally that is about 50 different folders per day (if I waited until the end of the week I would probably have to drop them into about 200 folders).
So is their a simple way to read in various files from one folder, then drop them in numerous other folders based on the Filename (my desired output)?