Hi ,
I have 15 different solutions to be executed daily for which the input source file is same . Is there a way to execute them simultaneously without really opening the file .
Thanks.
Hi @praneshsapmm ,
if you are talking about Excel flat files, then no. This is not a function of Alteryx, but a function of Excel. Excel is very much not a database.
There are things you can do, however. As you are probably finding, when your second workflow kicks in and tries to access the Excel file that is being accessed by another workflow it will error and say the file is unavailable.
Try the following:
1. Stop using Excel.
2. Convert the Excel file(s) to .yxdb. This will allow you to read the same file multiple times without simultaneously without problems, and the added bonus is it will load a lot quicker. This is true only if you are reading the file, not writing to the file, which results in it being locked.
3. Run the workflows in sequence rather than simultaneously. You might want to look at the Crew Macros - Runner Macros for this.
I hope this helps,
M.