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

How to change a value in a formula by using an user input action

emmanuel_varesio
7 - Meteor

Hi,

 

I'm struggling with the action tool to allow the user to update the "default value" of a SWITCH function containing an embedded Regex_Replace function (see attached workflow used as an example).

 

I would like to allow the user to modify the default value by entering its own text string but when using the update value with formula (action tool), the field in the Regex_Replace function is not recognized .... 

 

Thanks for your help.

 

Emmanuel

 

 

2 REPLIES 2
geraldo
13 - Pulsar

@emmanuel_varesio 

 

 

 


the switch has to have a comparison... I put IsNull(regex.....) to validate the consistency...

the way you are putting it only with the regex without comparing with anything it will give an error even in a simple formula...

emmanuel_varesio
7 - Meteor

Dear @geraldo ,

 

Thanks for your advice but if I include IsNull(regex...) then I'll get Null values for my Switch function .... I'm not sure to understand your point ...

 

Anyway, in the meantime I could find the solution by checking the "replace a specific string" option in the Action tool. I've attached the modified workflow.

 

Best,

 

Emmanuel

Labels
Top Solution Authors