Assign Values to Dynamically Renamed Column

[AnupK]

Hi All! New to Alteryx. I want to rename a particular column by a string which I need to extract from the filename of the input file. I have tried following method :

I could take filename as a column by selecting 'Output filename as Field' in input tool. Then by using 'Dynamic Rename' tool using 'Take Field Name From First Row of Data' able to rename this filename column with data in the first row. Next step should be copying data from another known column to this newly renamed column. Problem I am facing is since the new column name is dynamic, I can't use formula tool to assign values to this column from another column. 

Can someone please help me on this?

[CharlieS]

"new"? Sounds like you've hit the ground running, Nice.

I'm confident what you're describing is possible, but I'm having trouble imaging the situation. Could you share a workflow for the Community to look at? The best way is to use a Text Input tool (so no other files are necessary) with some sample data and what you've got so far. 

[fmvizcaino · Accepted solution]

Hi @AnupK ,

Here is a suggestion for you.

By using the multi-field tool, you can check the option 'dynamic or unknown fields' and guarantee that the formula will work for only the new filename column created.

You can change the filename in the text input to check the result.

Best,

Fernando Vizcaino

[AnupK]

Thank you @fmvizcaino. 

It worked. Dynamic Rename removed the first row so added it back to data using Select Record and Union.

[AnupK]

Thank you CharlieS, indeed it was possible.