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 have a folder with 5 excel files with different names but the exact same structure. I am trying to use the directory tool combined with the dynamic input tool to go to my folder, go to a specific sheet called "Raw Data" in each workbook and essentially stack the data in all 5 files on top of each other. I also want to add a column that contains the file path of each workbook.
In the directory tool, for "directory" I just have my folder path. For "File specification" I just have *.*
In the dynamic input tool, for "input data source template" I just chose one of the 5 files in my folder. Then for "field" I chose FullPath and "action" I chose Change File/Table Name
I keep getting an error saying that one of my 5 files does not match a sheet or named range in a different one of my 5 files. I've check the data and all my workbooks have the exact same structure.
Now, when you hit run, Alteryx will find the first xlsx file in that directory and pull it in (given the raw data tab), and then repeat this for all files, automatically stacking the data on top of each other.
When using this method, I would also change option 5, and output the filename as a field.
Also keep an eye out for the results pain, this will tell you if any files don't match the required schema, which is defined by the first table.
Also, lets say you have other files in your directory, then this method would require some more specific detail in the filename, such as a filename suffix that only exists on the files you want to bring in, for example