How do I use an translate files in alteryx ?

[patrikfrid]

Hi.
I have a file that containing translations for stock amount (calls Stock Correction), the stock amounts contains 0, 1, 2 and up to atleast 1000 (have around 1000 diffferent translations), so I do not want to add one by one as an filter. I want the translation file to translate 0 to replaced, 1 to yes and 2 to yes by using the translation file.

What do I need to use this translation file ?

[Thableaus · Accepted solution]

Hi @patrikfrid 

I suggest you to use the Find and Replace tool for that. It functions as a vlookup.

PS: The image that you appended is zoomed out and hard to visualize.

Cheers,

[patrikfrid]

Thanks @Thableaus 

it works exactly how I wanted it to work