replace a value in column

[#1]

How to replace a value in a column if the value of a  field in one table does not exist in another table?

[tresesco]

ApplyMap                                                          //if you are trying to replace in the table where values exist

Join and then replace (May be with an IF)        //if you are trying to replace in the table where values don't exist