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 am a noob with Alteryx and having trouble discerning the difference between Iterative and Batch Macros and finding the proverbial "Idiots Guide" to them. I'm sure my use case is extremely simple and I may be over thinking it, but here it goes:
I have a set of ~50 excel files with various sheets, only one of which is of interest and they are the same across all the Excel files in question. I essentially need a for loop to iterate over each file, grab a specific sheet, apply transformation steps to that sheet, and store it in a Database. The sheet is not structured into a tabular format. I have set up my workflow and it works for a single file, but when I introduce more that's where things go sideways. Below is a png of my current workflow:
This successfully recognizes the files I need, but appends the results of the spreadsheets which does nothing for me. I have scoured the board and I cannot find anything that satisfies my use case. Any help would be greatly appreciated. I'm hoping someone has come up against this.