Inputing multiple .xlsx files at once
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could look into using wildcards in the Input Tool's file specification. If that doesn't work it may help refine the question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check out these posts...
They might give you a starting point...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying that now - it is still running. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Input Tool accepts wildcard inputs.
Lots of information in these threads:
https://inspiringingenuity.net/2014/06/27/alteryx-wildcard-inputs/
If wildcard input isn't working for you then Dynamic Input also performs this job.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That helped. Thank you John!