multiple excel sheets = multiple input tools = tiring manual update of each input tool

Question

Hi, I have an excel source file that has multiple sheets that I will be cleaning separately. It is all good except whenever our source file is updated to a newer or revised version, I needed to update all input tools for each of the sheets that are connected to them (one sheet is connected to one input tool). How do I update the source file and all input tools will be updated according to their connected excel sheets? What input tool should I use instead? Or is there a setting in the input tool that can help me refresh the input tools automatically whenever I update the excel source file?

Help is very much appreciated. Thank you!

maddada · Answer

Thanks for the suggestion. Can I get a version where I can run it on a lower version of the Alteryx? I tried to check for updates, but it says that my version is already up to date. Not sure why it would not run your file.

If not, can I get screenshots of the properties portion of each tool that were used on the screenshots below, so I can copy and apply it on my end? Thanks again!

alteryx error.docx

Qiu · Answer

@maddada 
One way I can think of is to use the Analytic App, first get the file Path then update all the input tools

2nd method will the Dynamic Input.

This should be given that your sheets will not change.

0307-maddada.yxwz