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 ACriteria BSourceTargetA1C:\A\1D: \A1B1C:\B\1D: \B1A3C:\A\3D: \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!

Moving files based on the fields in Excel file

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	\A1
B	1	C:\B\1	\B1
A	3	C:\A\3	\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!

Input

Macros

Accepted answers

Joe_Mako

How about the attached?

Move Files.png

Move Files.yxmd

All comments

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

Target_Source.yxmd

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.

Joe_Mako

How about the attached?

Move Files.png

Move Files.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335