Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Copy the Excel together with the 3 sheets or tabs

KamenRider
11 - Bolide

Guys,

 

I would like to know what will be the correct workflow if I would like to duplicate a copy of my excel in other shared drive containing the 2 or 3 sheet tabs. I tried but it only copied the 1st sheet.

 

Please help 

 

Mar

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@KamenRider 
You mean read the contents and then write to the target folder?

or just simply copy the file?

KamenRider
11 - Bolide

Hi @Qiu 

 

Thanks for accommodating my inquiry. Well, I'd like to copy the file to a designated shared folder containing the sheets since it consist of two or more sheet tabs.

 

Is this possible?

 

Kamen

KamenRider
11 - Bolide

Hi @Qiu @atcodedog05

 

Any help guys.

 

Thanks,

 

Kamen

NikyN
9 - Comet

Hello there,

 

try attach macro -- it will just take a file and fully copy to new location. 

You need to save macro and load to the flow as single tool -- you need to pass two features (current location and new location).

 

Thank you!

 

Best luck!

Niky

Qiu
21 - Polaris
21 - Polaris

@KamenRider 
I believe mine is still the same idea with @NikyN 

Just a quick sample and you do need to provide the source and target path/

0216-KamenRider.PNG

Labels
Top Solution Authors