In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Copying data from one excel file to another file

learn_alteryx11
5 - Atom

Hi all, 

 

I am looking for a way out where we can copy the entire data from Sheet 'ABC' in excel file (say- master file) to multiple excel files containing data (say test 1) which may or may not contain Sheet 'ABC'. 

 

Basically, the data in Sheet 'ABC' of master file can be overwrite data in other files (test 1.xlsx, test 2.xlsx, test 3.xlsx, .. test 30.xlsx).

 

Thanks in advance! 

1 REPLY 1
jdminton
13 - Pulsar

The output tool will overwrite or add the sheet (image 1). If you add the filename to your workflow (can be a formula tool) to identify the path needed for the file, that can be used for the output to multiple files. (image 2)

Snag_23533a0a.png

Snag_2358111d.png

Labels
Top Solution Authors