How to input multiple files with same initial file names using a single tool?
- 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 4 files with the below file names. Can I input these together using a single tool?
Market Insight A 01022022.xlsx, Market Insight B 01022022.xlsx, Market Insight 01022022.xlsx and Market Insight A 01022022.xlsx
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @garvit1495 have a look at this article it will explains how to tackle your challenge.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes you can.
Drag Input Tool then give path\Market Insight *.xlsx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@garvit1495 , you can accomplish this by using an input data tool with the below configuration, it will union all the data from all the 4 files. But please note that the order and number of f shields should match in all 4 files, otherwise it will not give you the correct output.
Thanks!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@garvit1495 Replace the filename portion of the path with a wildcard “*” in the input tool.
Please refer to The Ultimate Input Data Flowchart - Alteryx Community
Thanks
![](/skins/images/626DE2D46E24383C4D47FE5A42A7D1D6/responsive_peak/images/icon_anonymous_message.png)