Copy files from directory with links in specific Excel cells

Question

Hello,

Need help with what should be just a simple flow, just unsure which function to use. I have an excel file that contains hyperlinks to files throughout my company's drive.

How would I copy/download a file from a specific cell then export it to a new spot in the drive?

Thanks!

TheOC · Answer

Hey @ekrohn113

Theres a few things to unpick here, but i think your general workflow would want to be:
- Input data tool, pull in the excel file

- Data Cleansing - identify the hyperlinks to files.

- Option 1/Option 2

Option 1 (if all files follow the same structure):

- Dynamic Input tool - input all the files together

- Output tool - output files to new location, making use of the 'Take File/Table Name From Field' to group the outputs.

Option 2:

- Create a batch macro that will read one file in at a time using a dynamic input tool. Outputting with the Output tool. You can learn about these here https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

Hope this helps!
TheOC