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.
"These macros are not an official Alteryx release and as such they have not been through the full testing process that tools in the product have. Some of them are prototypes and experimental, but that is some of what makes them so fun. "
I want to add one more option here, which is that if your 181 files have the same format and are in the same folder, you can include a wildcard character in an Input Data tool.
For example, if you had a folder named "Yourfolder" on the C:\ drive, and wanted to load Sheet 1 of all Excel files in this folder, you could configure your input data tool as follows:
C:\Yourfolder\ tells Alteryx what folder to look for.
*.xlsx tells Alteryx to look for ANY excel file in that folder. You can make this more specific by adding other characters, for example if all of the files you wanted start with the year (2019), you could use:
|||Sheet1 specifies that we are always looking for the first sheet in Alteryx.