What is the best way to translate multiple fields?

I have multiple fields that need to be translated. Is the best way to handle this to create a formula fore ach field? For example, one field is a gender translation from Male->M, another is Yes->Y, another is White->WH. Is there a way to have one tool do all of these translations?

Transformation

Accepted answers

atcodedog05

Hi @jhouseslu

Here is example

Input:

Output:

Hope this helps 🙂

Multi.yxmd

All comments

atcodedog05

Hi @jhouseslu

Best way would be multi-Field formula. Refer the link below.

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Field-Formulas/ta-p/424422

atcodedog05

Hi @jhouseslu

Can you give some sample data and logic so that i can help you out.

TheOC

Hi @jhouseslu,
I have provided an example, as @atcodedog05 said, best case is a multi-field formula. I'm sure there's a more elegant solution here but for one tool, this will do the job!

JHouseslu.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703