Hey guys i have and address field that needs to be cleansed. I have a reference table that has two columns. One column is the standard format and the other is the various incorrect format u may find.
I want to do a report just to show the before and after look of it after its been cleansed. What should i do.
Address New Address
123 main street 123 main St
345 jack rd 345 jack Rd