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.
You could look into using wildcards in the Input Tool's file specification. If that doesn't work it may help refine the question.
Check out these posts...
http://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Input-Multiple-Sheets-from-Multiple-Excel-Files/ta-p/4442
http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Input-multiple-Excel-sheets-or-tabs-at-once/ta-p/1243
They might give you a starting point...
I am trying that now - it is still running. Thanks!
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-multiple-excel/td-p/766
http://community.alteryx.com/t5/Data-Sources/using-dynamic-input-on-excel-files-with-different-tab-worksheet/td-p/3503
http://community.alteryx.com/t5/Data-Preparation-Blending/Difference-between-Directory-DYNAMIC-INPUT-vs-INPUT-only/td-p/7734
https://inspiringingenuity.net/2014/06/27/alteryx-wildcard-inputs/
If wildcard input isn't working for you then Dynamic Input also performs this job.
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"?
@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
That helped. Thank you John!
