file files with a unique id into a new created folder

[Ksisterhen]

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" 

[Warcry]

You'll use a directory tool to get the file names and then do your thing. 

File Specs:

for word docs, you'll have *.docx for only word, for excel its *.xlsx

If this solves your question accept this answer as your solution, thank you.

[Yoshiro_Fujimori]

@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.

[Warcry]

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.

[Warcry]

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.