Input files with asterisk and different name of worksheets

[altana]

Hi Team,

I would appreciate your help how to input more .xlsx files where the name of worksheet is different. The structure of the data included in all the files is same. I have more than 100 files.

Example how the files look like:

After running the wf I'm facing to this error. 

Thanks a lot

[JosephSerpis]

Hi @altana you should have a look at this article it will help you with your challenge. Plus also the solution from this post.

[Qiu]

@altana 
There is an article in the Alteryx Designer Knowledge Base for this topic.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

Basically we can use dynamic input or Directory tool as a start.