File Merge

[abroscow]

I am trying to merge files within the same subdirectory with different schema. As I understand it, with files in different folders, a dynamic input tool is needed. However, because I have one file with different schema, I am unable to merge all files using this method. Has anyone experienced something similar?

[Luke_C]

Hi @abroscow 

You're correct, the dynamic input will generally rely on a common schema. The alternative option is to use a batch macro. There are a number of topics on this that should get you going in the right direction:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-multiple-excel-files-wi...

[abroscow]

Thanks so much for the response. My issue with using a batch macro is all of these files are stored in different folders. Have you ever run into this dilemma?

[Luke_C · Accepted solution]

Hi @abroscow You had mentioned earlier they were in the same subdirectory. If they are in the same directory, but different folders, you could leverage a directory tool in Alteryx (checking the box to include subdirectories) to grab all of the file info (you may need to filter out files that aren't relevant)

[abroscow]

Thanks Luke - I was able to use a combination of a batch macro and some filters to get my desired output