Making changes to each file within a list

Question

So, I've been trying to figure this out for a bit now and was able to get some help in the form of an article on the directory tool, but I still feel very lost. So I have an excel sheet with a bunch of filenames in it (so I already have all the filenames) and i need to open each one, edit it, then save it as a new file. Do I need to make a macro to effectively do this? I don't want all the information from every file together, I want it to edit each file individually as well as save it individually. Help :(

Qiu · Answer

@ltensmeyer 
Would it be possible for you to provide a few dummy files and the changes required?

In that case, we can prepare a sample workflow maybe.

caltang · Answer

What you’re saying is for example, you have 10 excel files stored in a folder and from that 10, you know what to rename each of them and you have the renames in a list?

Then what you need may be the Run Command tool! https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamically-Rename-Output-File-that-Exists/td-p/1188110

ltensmeyer · Answer

@Qiu  Yes, so the files all have the same format and they all need the same changes made.