Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

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
Top Solution Authors