Change Cust Name with Formula function

[Ar13f]

Dear All,

I have customer segment data and I want to change it as below:

CustSeg	Change
Axytcrty Bdydrtu	AB
Pdrxc Uxyvtyio	PU
Xybxx Andtu	XA
Cxy Opudtxuit	CO

I created another table containing the name changes and connected the table above using the "Find & Replace" function and it worked.

What I want to ask is if this can be done with the "formula" function if so what is the formula?

Regards,

Arief

[atcodedog05 · Accepted solution]

Hi @Ar13f 

You can use the switch function or an else if ladder. But find and replace is the best option to go with. It is much better maintainable.

[Christina_H · Accepted solution]

Are you always replacing names with the initials?  If so, something like this might help:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Keep-only-Capitals-of-String/td-p/3700...

[atcodedog05]

Hi @Christina_H 

Interesting take on it 🙂. I didnt look at it that way.

Hi @Ar13f 

is there any logic behind it like first letters or capital letters.

[binay2448 · Accepted solution]

Please find attached solution, hope it work for you..

[atcodedog05]

Hi @Ar13f 

Here is my take on it.

Workflow:

Hope this helps : )

[Ar13f]

Dear @atcodedog05 

thank you for your advice, and I've tried with "switch" and it worked... 

I saw advice on this community how to use "switch", what I want to ask is what does "Null()" mean and can it be replaced with something else? for my case like this, how can it be replaced?

[atcodedog05]

Hi @Ar13f 

Here Null() is set as default in this usecase it is similar to else. If none of the condition matches then set to Null(). 

[Ar13f]

Dear @atcodedog05 , @Christina_H , @binay2448 

thank you all for your advice ... 

[atcodedog05]

Happy to help : ) @Ar13f 

Cheers and have a nice day!