community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.9

The latest release includes several enhancements designed to improve your Community experience!

Learn More

Copy tabs from Excel File into another Excel file (with same tab names)

Meteor

Hi

 

I receive a weekly excel file with the 10 tabs (sheets), I want to populate (overwrite) another excel file having the same tabs names.  What is the most efficient way to do this in Alteryx, rather than setting up input file/output file 10 different times.

 

thanks

Quasar

Are all the tabs the same layout? Or is each tab a different layout?

Meteor

Same layout, some tabs may have more rows than others.  Essentially I just want to copy the same tab into another file.

Quasar

See if this works how you want. I made it an Analytical App to demonstrate how you can use the File Browse to change the input spreadsheet.

Meteor

Unable to use this app.  Will not accept sheet name, won't run without sheet name

Hello,

Could you solve the problem you had in this post??? Now I'm in the same situation and I'm a bit lost.

Thanks in advance.

 

Labels