Moving files based on the fields in Excel file

[peterpark]

I'm trying to achieve batch command to move files, but based on the fields in Excel file / csv. Columns are "condition to meet", "source folder", and "target folder". For example,

Criteria A	Criteria B	Source	Target
A	1	C:\A\1	D:\A1
B	1	C:\B\1	D:\B1
A	3	C:\A\3	D:\A3

And so on. There are multiple files in the folder and we want to batch move all of them to its target folder. How is this done in Alteryx? Thanks!

[DanS]

Hey Peter, 

Would the attached work for you? 

It would filter based on your conditions and save to the correct file. 

Let me know!

Thanks,

Dan

[peterpark]

Unfortunately, this isn't actually moving files. I need to move one folder to another. I guess the criteria does not really matter in this case. Alteryx needs to look at Source, take all the files, and move to Target.

[gc]

How about building the BAT file command lines in an Alteryx string field. One row for each command. Then output as Flat file to a filename ending in BAT?

[Joe_Mako · Accepted solution]

How about the attached?