Merging Files from diff sub-folders
- 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
How do i merge multiple same files which are located in sub-folders
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @canitesh
You can directory tool and configure to include sub directory and read them using dynamic input tool or other options. Refer below post it might help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The Directory tool can also pull the filepaths from subfolders:
You'd then specify the needed full paths and use a dynamic input tool for loading it.
If this is an acceptable solution for you, please mark it as solved as it helps Alteryx to differentiate between open and closed cases.
Thanks
Matthias
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, I was able to merge those files from all sub-folders. But i need to add the file name in one of the columns so that i can differentiate each merged file. basically my files names are date wise so when i merge i should be able to figure out which date it is.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @canitesh
You can configure output filename as field both in input or dynamic input tool to get filename or fullpath.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry, this option comes when we use INPUT DATA. Right now i am using Directory-->Dynamic Output-->Browse. So where do i get option of Include File name as column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you help me with a screenshot pls?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @canitesh,
Sure here it is. When you set template by clicking on edit you will get this window where you set the template file where you can configure to output filename.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You are just Amazing. Very kind of you.
