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.

Dynamic Select- Automatic updates

kamels
5 - Atom

Hi, 

 

I have a workflow that I am trying to make as automated as possible. In an excel file that my data is coming from I have around 20 columns that are Months of the year. I am trying to find a way that the interface tool can automatically update the "March" to April. I have worked within the Interface tools a little bit, and I can't find a way that the action tool can update just the March in my formula. 

kamels_0-1759947841250.png

kamels_1-1759947906088.png

kamels_2-1759947933130.png

 

 

 

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

In your Action tool, select "Expression" as the value or attribute to update, and at the bottom of the Action tool select "Replace a Specific String" and only keep March in there

dreldrel
8 - Asteroid

Make sure you remove all other strings in "Replace a Specific String"  and dont modify the value in your dynamic select tool. I've seen some people change the values afterwards and spend time on finding this.

Labels
Top Solution Authors