topic Copy multiple excel file with different schema into individual tab of excel working file in Alteryx Designer Desktop Discussions

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

anubhavaggarwal — Mon, 25 Jan 2021 10:48:26 GMT

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

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

Qiu — Mon, 25 Jan 2021 10:51:21 GMT

@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

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

DavidP — Mon, 25 Jan 2021 11:11:23 GMT

Hi @anubhavaggarwal

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

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