The scenario involves two address/street lists that I’m trying to compare using the interval merge action to identify where mismatches exist between the two tables (great feature). It would be very useful if there was a way to create a mapping/renaming table where we could apply renaming of a value in one table to match the value in the other. I’m thinking of using the replace action on the field being used to link the two tables but then how do I obtain a list of all the replacements made as I need to know both the original source value and the replacement value. Do I create a copy of the column and then later derive a table that has distinct values where original field name != replacement field name. Is there a better way to approach this in EM?
PS, have been doing data analysis/cleansing for a long time and haven’t found a tool that comes close to doing what EM does - so many great actions that save a ton of time. The swiss army knife that every data analyst needs smile: