Append all files from folder

[Pkathuria12]

I have trying to read and append all macro enabled Excel files in a folder. I am not able to do so because of an error due to difference in file schema (most likely due to different data type). I want to resolve this issue and read all files, even if they have different schema. How should I go about it ?

[alexnajm]

The batch macro option here is your best bet: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[Inactive User]

I may not have the full picture, but what i would try is to:
1. Connect a directory tool to get the all the absolute paths of all files

2. create a batch macro that connects to one of them. The control parameter will update the absolute path for each itteration. It might be smart to enable "output file name" on the input tool that you update with the control parameter.

3. Make sure that in the interface designer you pick are as following:

[abacon]

Used this macro many times, super helpful to have. I have a template version saved on my desktop to easily use at any time.