community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Input Error - Does not match a sheet or named range

Highlighted
Atom

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.

Alteryx
Alteryx

Hi @lliberm1,

 

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. 

 

Let me know if you have any additional questions. 

 

Thanks!

 

Amelia

Labels