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
20 - Arcturus
20 - Arcturus

@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