Import multiple excel files with different schema

[RE5260]

Hi All,

I have a folder with multiple excel files with different schema. 

How can I import all the files together in Alteryx Designer?

Please help.

[Raj]

@RE5260 @The batch macro is an option, have you tried ?

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo...

[binuacs · Accepted solution]

@RE5260 @Use batch macro

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo...

[BRRLL99]

Please check this out

https://www.thedataschool.co.uk/vivien-ho/how-to-import-files-with-different-schema-using-a-batch-ma...

[Womack214]

I am getting an error when inserting the macro that says Record #1: Tool #1: No sheet specified. Where do I fix this at?