BAT before RUN move 1 file at a time

Question

I have workflow that requires to requires to transfer a pair of files at a time - 1 ZIP & 1 .CNTL file

Then the workflow will process these 2 files and append data into a table.

The source file has 60 ZIP and 60 CNTL files, how do I dynamically transfer these files 1 by 1?

ZIP File names = File_name_2020Jan.ZIP , File_name_2020Feb.ZIP, File_name_2020Mar.ZIP, etc....

CNTL File names = File_name_2020Jan.CNTL, File_name_2020Feb.CNTL, File_name_2020Mar.CNTL, etc....

Currently:

BAT job: Before RUN

xcopy "C:\Users\dmwang\Desktop\Relocate files\File_name_2020Jan.ZIP" "C:\Users\dmwang\Documents	esting\File_name_2020Jan.ZIP" /Y

xcopy "C:\Users\dmwang\Desktop\Relocate files\File_name_2020Jan.CNTL" "C:\Users\dmwang\Documents	esting\File_name_2020Jan.CNTL" /Y

I have tried:

xcopy "C:\Users\dmwang\Desktop\Relocate files\File_name_2020*" "C:\Users\dmwang\Documents	esting\File_name_2020*" /Y .... and it just transferes everything instead of 1 by 1 of ZIP and CNTL pair.

dmwang · Answer

The previously workflow was written to take 1 file instead of multiple files at the same time.

Constraint is that I can't change the workflow to take multiple files at the same time, because there is too much impact on other workflows that are dependent of each other.

OTrieger · Answer

@dmwang 
Why do you need that the files will be moved 1 by 1 and not all at once?

Because it is possible to get Alteryx to do it 1 by 1, but then need to understand what the logic to do it 1 by 1 as it might impact the development of how to do it.

dmwang · Answer

Also I used this as reference: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-Files-Copying-Files/td-p/443712