I’m running a process with require taking information from excel file. And i have that in Assign activity where i mention in the value the path of the file. After that i’m doing this Excel assign activity output as DataTable and using it in for each a lot of times.
So basically i want to make it after process end. Start again and automatically change the value with another excel file.
I have read that this is possible with config file with can contain all values for the excel files(paths) , but i’m not sure how.
Since i wanna fully automate it to don’t require person to manually change value of assign activity with another path after each time it ends. This way i can run it in Orchestrator which is the main goal. I guess i will need to LOOP the whole process and change the excel file to another.