Assign Values to Dynamically Renamed Column

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?

Developer

Accepted answers

fmvizcaino

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

2020-09-11 Assign Values to Dynamically Renamed Column.yxmd

All comments

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

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

2020-09-11 Assign Values to Dynamically Renamed Column.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703