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