Merging Files from diff sub-folders

[canitesh]

How do i merge multiple same files which are located in sub-folders

[atcodedog05]

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/t...

[MatthiasSeil]

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

[canitesh]

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. 

[atcodedog05]

Hi @canitesh 

You can configure output filename as field both in input or dynamic input tool to get filename or fullpath.

Hope this helps : )

[canitesh]

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.

[atcodedog05]

Hi @canitesh 

You will get this option in dynamic input tool while setting the template.

[canitesh]

Can you help me with a screenshot pls?

[atcodedog05]

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 : )

[canitesh · Accepted solution]

You are just Amazing. Very kind of you.