This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.