Retrieve and join Mutiple files from 1 folder.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
amorej
7 - Meteor
‎07-08-2024
10:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How do I retrieve and join mutiple files from 1 folder?
Labels:
- Labels:
- Input
1 REPLY 1
12 - Quasar
‎07-08-2024
11:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Do you want to Join or Union them? Are the schemas the same? If you're wanting to Union with the same schemas, you can use a wildcard in the Input Tool. For what I have below, it'll import all files in that folder that are xlsx and have the same tab name (tab name not shown in the picture).  
Edit: This flowchart might help. It talks about the different ways to import multiple files with minimal tools - https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
