Inputing multiple .xlsx files at once

[Mdillard]

I have about 100 excel files that I am trying to input and combine. Is there a quick way to do this? I do not want to enter 100 input data tools then union them all together.

[JohnJPS · Accepted solution]

You could look into using wildcards in the Input Tool's file specification. If that doesn't work it may help refine the question.

[RodL]

Check out these posts...

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Input-Multiple-Sheets-from-Multiple-Ex...

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Input-multiple-Excel-sheets-or-tabs-at-once/t...

They might give you a starting point...

[Mdillard]

I am trying that now - it is still running. Thanks!

[michael_treadwell]

Input Tool accepts wildcard inputs.

Lots of information in these threads:

http://community.alteryx.com/t5/Advanced-Analytics/Directory-and-Dynamic-Input-Tool-for-inputting-mu...

http://community.alteryx.com/t5/Data-Sources/using-dynamic-input-on-excel-files-with-different-tab-w...

http://community.alteryx.com/t5/Data-Preparation-Blending/Difference-between-Directory-DYNAMIC-INPUT...

https://inspiringingenuity.net/2014/06/27/alteryx-wildcard-inputs/

If wildcard input isn't working for you then Dynamic Input also performs this job.

[Spatel68]

Hi,

There there way to use *.xlsx to stack all excel file, except one (with specific string).  So something like *.xlsx where filename does not contain "xxxxx"?

[JohnJPS]

@Spatel68,

If you read them all in and include the filename as a separate column, then you can easily filter out the rows from that file.

Hope that helps,

John

[Spatel68]

That helped.  Thank you John!