Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

anubhavaggarwal
5 - Atom

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 

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

Hi @anubhavaggarwal 

 

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

 

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

Labels