Copy multiple excel file with different schema into individual tab of excel working file

Question

HI All,

I use various excel input files with different schema  and copy then into individual tabs of a excel working file which has a set of formula which pick numbers from these individual tabs for calculation purposes.

Can i perform this copy paste process using Alteryx as currently i am using excel macro to perform this steps.

Thanks

DavidP · Answer

Hi @anubhavaggarwal

I would also look at the Crew macros, Wildcard XLSX input tool.

http://www.chaosreignswithin.com/p/macros.html

Qiu · Answer

@anubhavaggarwal 
I think this is often asked question. Check below if it helps.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multiple-Schema-Inport/td-p/472455

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-Multiple-Tabs-that-have/ta-p/51145