Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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