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
@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
I would also look at the Crew macros, Wildcard XLSX input tool.