Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

How do I update the input files automatically in an weekly scheduled analytic app

5 - Atom

Hi community,


I am new at Alteryx. I have built an analytic app which I plan to run on weekly schedule on the gallery. The input data is sourced from excel files. However, these excel files which are to be used as input are updated every week. Currently I have used File browse interface tool to update the excel files. Is there any way in which this exercise can be automated like for ex: the file browse tool automatically picks up the excel file from a specific location on the computer??









I'd probably use a combination of the Directory tool and Dynamic input as described in the option no 2 here and build a logic to pick up the latest file. This way the File Browse is not required.


Also, when running on the Gallery, please make sure that the directory is referenced using the UNC path and is accessible from the server.