In the attached workflow, I would like to rename the Ending Amount column to the FileName. In the attached, I am getting to the correct output, but I am trying to get away from creating a new column in the Formula tool. I also plan on having multiple input files (i.e. xyz company), so I also want to avoid choosing the existing abc company column in the Formula tool. Any thoughts on how to automate this workflow so I do not have to update the Formula tool for every new company?
Thanks!
Solved! Go to Solution.
Happy to help : ) @dperez1
Cheers and have a nice day!
thanks so much @atcodedog05 . Likewise!