Find & Replace / Join Tool : can't replace data because of different fields

Question

Hi everybody,

I have to translate the data of a field. I have a translation dataset that I use. I tried using Find & Replace but since the field where it looks for the information is not the same as the one I need to translate it doesn't work. Basically it looks by the field "Base" so it replaces in the output field "Base" but I need to replace in the field "Description"

So I came up with another solution but I am wondering if there is a nicer way to do it. Basically I use a Join tool to add a column with all the translation it finds, use a formula tool to add a column to the output dataset where it didn't find a translation and then a union tool to put it all back together.

Let me know what you think,

Best

Copy of Assembly Scrap Report.yxmd

Assembly Area Database.xlsx

Query Final por Tx 51  SCRAP Controller _ 1328289 _ 2218960.xlsx

Traduccion Scrap 15.06.21.xlsx

iCFO · Answer

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Replace-Tool-unmatched-fields-unchanged-instead-of-null/td-p/429491/page/2

Here is a link to my iterative find and replace in case you are interested.

iCFO · Answer

I built an iterative version of the find and replace tool that can achieve this as well if you use a custom formula option to compare the 2 different fields. I wouldn’t recommend the approach unless you wanted to build a user friendly excel controller or something.

atcodedog05 · Answer

Hi @Victouf

I think i got your question you are speaking about the highlighted formula part.

Nope sadly what you are speaking is not possible. What you have done is the right approach. Thats the only way it can be done.

Hope this helps : )