Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to change a default field value

Andy_Katona
8 - 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.

6 REPLIES 6
MarqueeCrew
20 - Arcturus
20 - Arcturus

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 restart. Order shall return.
Please Subscribe to my youTube channel.
Andy_Katona
8 - 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.

MarqueeCrew
20 - Arcturus
20 - Arcturus

@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 restart. Order shall return.
Please Subscribe to my youTube channel.
JoeM
Alteryx Alumni (Retired)

@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
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Andy_Katona
8 - 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