Change name of input file - MS Excel

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.

Database Connection

Accepted answers

binu_acs

@david_potrubacz read your files using the directory tool and extract the file you want using a batch macro

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

All comments

alexnajm

This should give you some direction! The only difference may be how you filter to the file you want: How to dynamically run the most recent file in a file folder

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

JosephSerpis

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.

david_potrubacz

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.

david_potrubacz

Screenshot 2024-11-04 113851.png

binu_acs

@david_potrubacz read your files using the directory tool and extract the file you want using a batch macro

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703