This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is there a tool or set of process in Alteryx to compare address data between two tables and merge the bad records with a clean one. I am dealing with cleaning up of postal addresses. One is a reference address table (good) and the other table has good and bad address data. I couldnt find much details in the forums here but any information would be helpful here to have a go at this task.
Dear Vinod, Please explain your problem in a bit more detail - say with couple of examples. Seems an application of Fuzzy Matching may work in here but actual solution would only emerge once the problem definition is clear with constraints.
Even I'm facing the same problem....have couple of tables related to Country Names and Codes...one is a reference and other is dirty...need to somehow match the two and find the ones which are similar. I think we need something like Fuzzy Lookup Transformation in SSIS. The Fuzzy match in Alteryx doesn't work the same way I guess....also, there aren't any tutorials clearly explaining its use.