How to change a default field value

Question

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 Answer

Use a FORMULA Tool.

Select the field.

Here is the code:

"SupplProv"

smiles,

Mark

MarqueeCrew · Accepted Answer

@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#M51

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

Password: Data123

Cheers,

Mark

MarqueeCrew · Accepted Answer

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

Andy_Katona · Accepted Answer

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