How to change a default field value

[Andy_Katona]

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.

[MarqueeCrew · Accepted solution]

Use a FORMULA Tool.

Select the field.

Here is the code:

"SupplProv"

smiles,

Mark

[Andy_Katona]

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.

[MarqueeCrew · Accepted solution]

@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

[JoeM]

@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

[MarqueeCrew · Accepted solution]

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

[Andy_Katona · Accepted solution]

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. :-)