Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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