Manually overwrite input data

[peterlyngvig]

Hi,

I import data from a 3rd party database. Occasionally, there are errors in the dataset. See table 1 and table 2 below in the picture. Now, I would like to be able to correct this using Alteryx. I could do this using a Formula tool, Replace & Find or similar, but wonder if there is a smarter way. I.e. is there a tool, where I could input something like table 3, which highlights ID#, which column to be corrected as well as the value to overwrite with. What would be the smartest / most efficient way to do this in Alteryx?

[JBO]

Do you usually only have a few you need to correct? If yes, I would just use a simple conditional statement in the formula tool:

[grazitti_sapna · Accepted solution]

Hi @peterlyngvig 
There can be multiple ways to do this but I have tried it with join tool to get the desired output.
Try the below workflow and let me know if it worked for you or not.
Thanks

[peterlyngvig]

Thanks!