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.
New to the boards and needing a little help. I have about 200 Excel files with different names that i'm needing to process. They each contain about 10 worksheets that need to be read in. I'm struggling to find the best way to do this.
Also needing to capture the unique Excel file name as i'm reading each of the 10 worksheets and the worksheet name as well. Any chance anyone in the community has dealt with this?
Thanks for the suggestion Joe. Here's the catch. these excels are formatted horribly. While they are consistent, i'll have to specify specific rows and omit certain columns. I managed to find the select records tool which seems to do the job. I'm wondering if there is a way to reuse the logic you have in your Macro to do the other tasks (capture file name and worksheet name, looping etc.).
I haven't worked with Macros in Alteryx but would be great to take this opportunity to learn it. Any chance you have some thoughts on this?