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 bunch of excel files with multiple sheets. I am looking to pull info out of one sheet which is consistently named in each workbook but may not be present in all workbooks. I would like the files skipped or shown as null when inputting but i am getting the error "Does not match a sheet or named range" and the run breaks down. I am new to alteryx so if there is an easy work around that will be helpful.
Thanks for your question! It sounds like you might be using the Dynamic Input tool currently. Instead, try using a batch macro. They are a bit more flexible as to allow for slight changes in the data schema without breaking. This community article walks you through how to set this up and even provides an example.