Store User Input from Textbox as Column Name

[andrewc22]

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

[pedrodrfaria]

Hi @andrewc22 

See attached for the WF.

In the action tool, you need to make sure to flag the field or part of the field you want it to replace. In this case I want to replace in my formula function "Name".

Pedro.

[andrewc22]

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 

[patrick_digan]

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

[pedrodrfaria]

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.