Change Cust Name with Formula function

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

Datasets

Output

Tips and Tricks

Accepted answers

atcodedog05

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

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/370002

binay2448

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

Change Cust Name with Formula function.yxmd

All comments

atcodedog05

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

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/370002

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

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

Change Cust Name with Formula function.yxmd

atcodedog05

Hi @Ar13f

Here is my take on it.

Workflow:

Hope this helps : )

abv.yxmd

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?

Ar13f

Dear @atcodedog05 , @Christina_H , @binay2448

thank you all for your advice ...

atcodedog05

Happy to help : ) @Ar13f

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703