Import multiple excel files with different schema

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.

Workflow

Tips and Tricks

Accepted answers

@RE5260 @Use batch macro

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

All comments

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

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

@RE5260 @Use batch macro

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Please check this out

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703