community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

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

Meteor

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

Alteryx Certified Partner

@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. 

Magnetar
Magnetar

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.

Labels