Move multiple formats of excel from one folder to the other & folders' path changes

Question

Hi all,

I need to:

1. Move multiple formats of excel (like xlsx/csv/xls) from one folder to the other.

2. These folders' path changes every time. For example, I move many excel files from [Bank details] to [Bank details Archive] in Alteryx\Cash_flow\202403\, next month I will move files from [Bank details] to [Bank details Archive] in Alteryx\Cash_flow\202404\.

Is there any solution? Both questions are hard to me.

bgreedy · Answer

Ah, you could add a formula to filter the cash flow folder by the current month, provided the folders always follow the same format this should work

Copy Files.yxmd

Nico67543 · Answer

Thanks! It works!!!

But there is still a question, this month I move file from [bank details] to [bank details archive] in 202403, and next month I will move them from [bank details] to [bank details archive] in 202404, how to make it automatic？

bgreedy · Answer

Hi,

You could do this using a "run command" tool, see the example workflow attached.

The "Directory" tool specifies the folder containing the files

The "Accepted File Types" tool lists the file extensions you want to extract

The current version copies the files from to the archive folder,  however if you wanted to move the files (removing them from the original folder) you could the modify cmd in Formula (29) cmd from "copy" to "move"

Copy Files.yxmd