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

Alteryx designer Discussions

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

CREW Wildcard Batch Macro Error

Meteoroid

Hello All,

 

I am attempting to use the CREW wildcard macro to input a file with information in 23 tabs. 

 

I am getting an error for three of my tabs from Tool #4 in the macro saying that "'tab name' does not match a sheet or named range in 'file path'". I am trying to figure out what about these three tabs is different from the others. I went to to the source of the error in the macro and ran then through individually, and they seemed to work.

 

Has anyone else ran into this error or know what could possibly be causing it?

 

Any help appreciated!

Alteryx Certified Partner
Alteryx Certified Partner

@aderdiger,

 

CReW has 2 "Wildcard" macros: Wildcard Input & Wildcard XLSX Input.  There is also a similar macro in the gallery "Read_all_Excel_Files" that I recommend.  I looked at both of the macros from CReW and did not find a Tool #4.  Please try another tool and if you've got more details to share, I'll try to take a look at this for you.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels