How to automate excel files to ingest it in a workflow?

[Eworabo]

Team, 

Every week we have different files, instead of manually changing the input browser folder, we want to automate it? What's the best practice to resolve it? 

Thank you, 

EW

[CharlieS · Accepted solution]

@Eworabo

If the files are in the same directory, then I recommend using a Directory Input tool. This tool will input all files in a folder, You can use this list and other Alteryx tools to identify the specific file you're interested in (for example, the last one created). If the file has the same field structure every time, a Dynamic input can use that file path and input the file like the original each time. 

[Claje · Accepted solution]

Do your files follow a specific naming convention? IE Vendorname_20180619.xlsx ?  If so, you can use an * as a wildcard for the date.  Something like Vendorname_*.xlsx will pick up any excel file starting with Vendorname_ .

If the filenames vary completely, you could use *.xlsx inside your folder to read in all excel files.