Store User Input from Textbox as Column Name

Question

I would like to store the user input string from a text box as a column name in a formula tool

My application takes in 2 files and the user will name the files, I need the names of the files so the user can know which data is from either file in the output excel sheet. I am having trouble storing the input, my workflow will only hard code whatever name I type in the formula tool instead of replacing it with the user input string.

I have included a screenshot of my workflow below

workflow.PNG

pedrodrfaria · Answer

Oh @andrewc22 , you want to replace the column name? and not the data?

You would then need to do this.

However, I'm not sure the logic you have set up, but changing the column name will affect the tools used afterwards with the column named used to create the workflow.

patrick_digan · Answer

@andrewc22 Can you send a screen shot of how your action tool is configured?

andrewc22 · Answer

I tried this but it wouldnt work, do you think it is due to the column name I am trying to replace is created in the formula tool? @pedrodrfaria