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!