How do i merge multiple same files which are located in sub-folders
You are just Amazing. Very kind of you.
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.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
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
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.
You will get this option in dynamic input tool while setting the template.
Can you help me with a screenshot pls?
