Append all files from folder

Question

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 ?

abacon · Answer

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

unknown · Answer

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:

interface designer options.png

alexnajm · Answer

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