community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to change a default field value

Asteroid

Team,

 

I have the need to change the value of a field from string value to another. For example: Column_A = "Hospital". I need Column_A to equal "SupplProv" instead of "Hospital". How do I change that? I have tried the expressions switch, replace, etc...

 

I also have the need to take a Column_B that has no values & store a "S" in that field.

 

Thank you for your help & guidance.

Alteryx Certified Partner
Alteryx Certified Partner

Use a FORMULA Tool.

Select the field.

 

Here is the code:

"SupplProv"

smiles,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

I fought this for 4hrs yesterday. I thought I had to write a specific expression for the whole thing.

 

Just by selecting the column & in the expression filed typing the value; e.g. "S" it would replace the text.

 

THANK YOU SO MUCH!!

 

I have had this tool for 5 days & it has simplified by work so much.

Alteryx Certified Partner
Alteryx Certified Partner

@Andy_Katona,

 

Young man, I hope that this has taught you a lesson!  Don't fight challenges in Alteryx.  Do explore and do ask for help. I'm glad that we were able to get you going again.  I'm about to take some training from @JoeM on regular expressions.  Why not jump ahead and join the live training? 

 

https://community.alteryx.com/t5/Live-Training/2017-03-28-Parsing-with-Regular-Expressions/m-p/48576...

 

https://alteryx.webex.com/alteryx/onstage/g.php?MTID=eed4ef9160616ca0b2286fad3fddf6d1a

Password: Data123

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Director, Customer Enablement
Director, Customer Enablement

@MarqueeCrew

This was the incorrectly set training reminder (which has since been rectified) - the class is set to take place on 3/28. However, we will be starting predictive grouping shortly!!!

https://community.alteryx.com/t5/Live-Training/2017-03-07-Cluster-Analysis-Basics/m-p/47175#U47175

Alteryx Certified Partner
Alteryx Certified Partner

I stand corrected and will be in attendance to the clustering class.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Asteroid

Thank you, I wanted to join today's call after I found it. Yet, my schedule didn't match up. Thus, I did put all the other live trainings on my calendar for the future. :-)

Labels