Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to modify every file in a directory, then save a copy to an updated folder

mgiese
5 - Atom

Hello!

 

I have a file directory with ~70 nearly identical files that need to be opened, have one column converted to uppercase, then saved into a new folder with original file name. I attempted to use the directory tool and dynamic input tool to pull in the files, but then couldn't figure out how to save them. I apologize for the lack of attached workflow or screenshots.

 

I would like to pick my directory, pick my save location, and then repeat the data cleansing process on each of the files in a batch as opposed to one at a time. Is this possible to do?

 

Thank you for your assistance.

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

Hey @mgiese ,

 

You need to get the filename from each file from the dynamic input tool and configure the output tool as follows.

fmvizcaino_0-1642029728407.png

 

Thanks,

Fernando Vizcaino

 

Labels