file files with a unique id into a new created folder

Question

I want to create a workflow that looks at all files in a certain folder and then pulls files with a Unique ID in the title into a new folder. i.e files with Jones in them to be moved to a new folder titled": Jones, files with name "smith" in them to be moved to a new folder titled: "Smith"

Capture.PNG

Warcry · Answer

According to the ACE, Alteryx is not good at file operations. Go ahead and use Run Command tool and pass the CMD script move [Path of your file] [Path of where you want to move it].

Example attached.

RunCommand Config.yxmd

Warcry · Answer

In that case, you don't need Alteryx, you can always use tools that won't break the bank for almost anything and everything Alteryx can do for citizen developers.

Yoshiro_Fujimori · Answer

@Ksisterhen ,

If the requirement is just moving files without transforming the data contents,

it would be easier with PowerShell or Command Prompt, rather than with Alteryx.

(Alteryx is good at ETL, but not so much at file operations.)

You may want to ask AI chat service how to do it. Good luck.