Read File List

[#1]

This macros will read a list of files and will concatenate the columns in each file by name. This allows users the ability to read numerous files that have different column Schema's without error. 

[RWvanLeeuwen]

The only thing you download when you click the button is that you get a file called <files.jpg>
no macro here, just an image

[KSowers]

Whoops! Thanks for pointing that out, attached the macro image instead of the macro! Lol

[RWvanLeeuwen]

Thanks Kevin!

[Hi2023]

I ran it but I got the Control Parameter must be mapped to a field error?

[KSowers]

@Hi2023 If you click on the macro itself, you'll see on the configuration panel on the left that you just have to tell the macro which column of your data has the list of filepath's within it. The macro will batch through this list and read each file. Let me know if you are still having issues!

[Hi2023]

 I am not completely understanding what you mean. This will be able to read multiple files with different columns?

[Hi2023]

I am trying to join multiple reports and some of the sheets from these reports but the columns are not the same.