Read Excel file of Different and same schema.

[rohit782192]

I have more than 100+ Different Excel File .xlxs and it is kept in a folder. I want to pick all the excel file in one go and few excel file is of Different Schema and Few excel file is of same schema. How can we develop a workflow in Alteryx.

[binuacs]

@rohit782192 Do you want to combine all the Excel files into one output? If yes then you can try the batch macro

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

[rohit782192]

I have 5 files with same schema and one file with Different schema but different schema file is only pick while rest are ignored.

[binuacs]

@rohit782192 The batch macro picks all the files and combines them into one, you connect your batch macro output to a browser tool and run the workflow you will be seeing the result

[rohit782192]

Can you help like what to change. I tried but no luck 

[rohit782192 · Accepted solution]

We have to use crew macro for the same.

https://community.alteryx.com/t5/Dev-Space/Crew-Macros-Download-Link/td-p/1040387