Copy Excel File and Move to Folder

tolson

Hello all,

I am very new to Alteryx and have the following problem. I have several hundred excel files that are located in different folders.  They all have the same name except for the first word. Is there a way to copy those files and place them in one consolidated folder?

joelmiller66

Hi @tolson - The process of 'copy/pasting' within your machine environment would be more of an RPA (Robotic Process Automation) process.

In Alteryx if you want to read in files from folders the tool you would start with the Directory Tool found in the In/Out Category. This tool will return a list of files located in folders which you then can use Alteryx to read in those files.

Within the Directory Tool you have the ability to pinpoint the files you are trying to read in. It sounds like you will want to use the wildcard (*) at the beginning and then put the rest of the file name in the File Specification. And since you have multiple folders, you would also want to check the 'Include Subdirectories'.