topic Re: Input files with asterisk and different name of worksheets in Alteryx Designer Desktop Discussions

Input files with asterisk and different name of worksheets

altana — Tue, 26 Apr 2022 16:22:19 GMT

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

Re: Input files with asterisk and different name of worksheets

JosephSerpis — Tue, 26 Apr 2022 16:25:12 GMT

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

Re: Input files with asterisk and different name of worksheets

Qiu — Tue, 26 Apr 2022 23:10:02 GMT

@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-or-a-Specific-Excel-Range/ta-p/398220

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