What is the best way to translate multiple fields?

[jhouseslu]

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?

[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!

[atcodedog05 · Accepted solution]

Hi @jhouseslu 

Here is example

Input:

Output:

Hope this helps 🙂

[jhouseslu]

This works nicely. Thank you.

[atcodedog05]

Happy to help 🙂 @jhouseslu 

Cheers and Happy Analysing 😀