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.
I'm using alteryx to populate a central database of monthly performance data.
Each month I receive a monthly spreadsheet of data, I'm currently saving them in different folder using the file path below
c:data/performance of assets/2019/01/January performance data.xlsx
c:data/performance of assets/2019/02/February performance data.xlsx
c:data/performance of assets/2019/03/March performance data.xlsx
In this example we would not yet have the April spreadsheet so the fourth folder would be empty
c:data/performance of assets/2019/04/
I have a workflow which clears up the data, applies some statistical analysis and stores the resulting information in a central spreadsheet. This can then be used to generate performance reporting.
My issue is that all of this works fine if every month i manually link Alteryx to the input spreadsheets, however I can't figure a way to tell it to look in each the 12 monthly folders and pull in the data input spreadsheet only if the spreadsheet is there.
With this you can use a dynamic input and then tell alteryx to check subfolders as well. If the file structure is the same and the naming convention of the new file is the same then you can wild card your input and use a single input into your workflow
c:data/performance of assets/*performance data.xlsx
In your input tool you can check the box that says Search SubDirs and it will look for the same structure throughout all subdirectories
That is one option or your second is to create and active director of your files
The asterisk that I had included in the line is the "wild Card" this basically tells the engine to pull everything from the current file and (if you checked the subdir box on the input) all subdiurectories where the file ends in _____.xls
Let me know if you need more and I will try to include and image to help explain this.
Better yet... I just located an article on community that explains all the options and how
You will need an iterative macro that will basically read through and pick up each file. If you do a search on the community board there are several people who have posted samples of what this iterative macro needs to look like and/or provided theirs for people to modify and use.