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.
First time posting here! I have a workflow that runs successfully if I use a single file as my data input. My end goal is to be able to point my workflow at a specific file location containing many files, which will then be picked up and run one at a time through my workflow. I am having a lot of trouble trying to find the best way to do this, so any help or suggestions would be greatly appreciated.
Thanks for the reply. The issue I'm having with this is each file from the location needs to go through the whole workflow (including the output) before moving onto the next file. The solution you've posted works great, aside from the fact it brings in all of the files together and then runs them as one output before splitting out each file right at the end.
What you need then is a macro to do the process in batch. The macro image is in the black box. This gets every file and process it one by one. This one does although the same calculations for each file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A separate point, the workflow now in my batch macro will run for a single file in about 2 seconds, however, when I've now packaged it into the batch macro the run of that macro is projected to take longer than an hour. Is this normal?
Glad it helped you. I am sorry but I am not sure if I am understanding you. Are you telling me, it takes you about 2 seconds to run the macro (doing a test run within the worfkow of the macro I suppose), but if you use the macro and do input the parameters it takes an hour? Just for the same single file?
If thats the case it is not normal. There must be something that you are missing somewhere. Processing the information in a batch macro takes longer than doing it in a workflow yes, but we are talking about a 10 to 20% longer (at max), not from 2 seconds to an hour.