Alteryx Designer Desktop Discussions

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

Change the data in one field based upon the first 5 letters of a different field

eabonacci22
5 - Atom
If my Matter # begins with VWXYZ then the Location should be "Israel" instead of Great Britain. How would I write that formula?
5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@eabonacci22 
There is a String function "StartWith", maybe we can use.

0218-eabonacci22.PNG

eabonacci22
5 - Atom

Thank you so much!  I am a rank beginner with this software and greatly appreciate the help!  Worked like a charm.

eabonacci22
5 - Atom

It seems I still have a problem.  When I use the script you provided the following happens:

eabonacci22_0-1645214619537.png

 

What I need is the following:

eabonacci22_1-1645214680991.png

 

How should I revise the script such that the location doesn't change except when the Matter # begins with "VWXYX"?

 

I appreciate the help!

 

atcodedog05
22 - Nova
22 - Nova

Hi @eabonacci22 

 

Can you share this data in excel file.

atcodedog05
22 - Nova
22 - Nova

Hi @eabonacci22 

 

It would be something like this

 

atcodedog05_0-1645215033140.png

 

Hope this helps : )

 

Labels
Top Solution Authors