Changing Content of Column Based on Lookup Table

[altbc2]

Hi folks, 

I was wondering if anyone had any ideas on changing the values in a column based on the values of a lookup table. If there is no match, then it should change to a default value. I've done the first part using the Find Replace tool, but I'm having trouble with the second part. I'd appreciate any help. Thanks!

[fmvizcaino]

Hey @altbc2 ,

Something like this? Instead of replacing, append the field and include a condition to it.

Best,

Fernando Vizcaino

[Qiu]

@altbc2 
I feel it is more a Join problem here.