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 trying to build a workflow that filters for specified account numbers from an income statement. I have 15 files of the same set-up (same spreadsheet names and file formats) and I have been trying to build a batch macro to input all of the files at once into my workflow and pull out each account number from the same sheet from each individual excel file.
It's been driving me crazy so any help would be greatly appreciated!
You may not need to build out a batch macro for this. The Input Data tool can be configured with wildcards so that it'll read in all files that match. The only caveat to this is if the table schema changes in any of the Excel sheets it's reading in, it'll skip that file (which is where a Batch macro would be needed).
In the example below, this would tell it to read any file that starts with "incomestatement and ends with ".xlsx" from the the directory "C:\directory\". The sheet name in each Excel file also has to match to use this option.
Outside of this, you may be able to find macros shared throughout Community or published on gallery.alteryx.com.