Dynamic & copy

Question

Hello All,

We have daily Input files copied into our shared drive out which I'm interested in bringing in the below two files for my workflow

File 1 = xxxxxxxxx_xxxxxx_-_xxxxx_xxxxxx_xxxxxxxx_xxxxx-xx-xx_2021-01-14xxxxxxxxxxx.xlsx
( This excel file has only one worksheet and it will be the same schema everyday.)

File 2 = xxxxxxx_xxxx_xxxx_xx_xxx-xx-xx_2021-01-14xxxxxxxxxxx.xlsx
(This excel file has multiple sheets and th schemas are different for each worksheet)

- Firstly I want to copy todays files from the shared directory to my local directory.
- Then I want to produce a log file saying the files copied are todays file.
- Then I want to make this dynamic so everyday when I run the workflow firstly it has to pick the above two files as of todays date and then copy from shared drive to local desktop folder..

Any thoughts on how to go about with this

Amarendra · Answer

Feel free to revert back with more questions

micky01 · Answer

Thanks for the reference.

Amarendra · Answer

Hello @micky01

Here are some helper articles to deal with different schemas. I am sharing  the below just in case you need to standardize the file schemas.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Read-in-Multiple-Excel-Files-with-Multiple-Tabs-that-have/ta-p/51145

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

1. How about renaming the file outputs with date and time?

2. You can them pick them up based on a condition and finally write back to the shared drive

Here are some ideas

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-Files-to-a-Shared-Drive/td-p/456761

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-a-shared-drive-but-if-I-cannot-connect-output-to/td-p/193164