I have a workflow that uses 6 tabs from the same MS Excel worksheet. Each tab has a different name and different data layout. Each week I need to go into each input tool and change the file name to something like Data10282024.xlsx to Data11042024. Is there a way to change the name of the spreadsheet in one place (to the current date) and it will change the name in all 6 of the input tools? Thanks.
you can use this to read in the sheet names from the file, create new paths with those sheet names, and read them all in using the same Dynamic Input method
Hi @david_potrubacz to answer one specific point of your quesitons if you to Options - Advanced Options - Workflow Dependencies you can change the file for all your Inputs in one location. However you would have to do this every week. Building your workflow to dynamically run with the most recent file would be my approach as you then won't have to make changes everytime before you run your workflow.
Sorry, maybe I wasn't clear. Here is what I am trying to do. - In the workflow below 3 input tools are referencing the same spreadsheet. How do I change DataSheet_1028204.xlsx to DataSheet11042024.xlsx without having to go in and change each of the input tools? Thanks.
