In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Using Dynamic Rename to change Field

neromerob
10 - Fireball

Hello to everyone. 

 

I´m building a workflow where I must change this dynamic field 

 

change.JPG

 

into 2021_03; 2021_04 and so on. 

 

I know that i have to used a dynamic tool but I´m not sure about the code that i have to use.

Thank You . 

3 REPLIES 3
TheCoffeeDude
11 - Bolide

If all you're doing is removing "Sum_" from the values of column A, why not use the formula tool to remove it?

 

TheCoffeeDude_0-1654321085553.png

 

TheCoffeeDude
11 - Bolide

If you have to insist on using dynamic rename:

TheCoffeeDude_0-1654322413022.png

 

Here's the text of the second input file (R anchor - replacement data stream):

TheCoffeeDude_1-1654322516433.png

 

Qiu
21 - Polaris
21 - Polaris

@neromerob 
@TheCoffeeDude gives good sample for using Dynamic Replace.
I noticed that you want the output to be "2021_03; 2021_04", so made minor modifications.
of course, we can use Formula tool or RegEx for this also.

0606_neromerob.PNG0606_neromerob-1.PNG

Labels
Top Solution Authors