These are my 2 data sets and these are not 100% match if I use the join tool with the Name as unique. It wont match. Can anyone suggest how this be done in any other way?
Solved! Go to Solution.
You would have to use fuzzy match tool. Can you provide smaple data in excel file so i that i can help you out with a workflow.
Here is how you can do it. I had to change corporation to crop because even through they were same word difference in chars were far apart.
Workflow:
Hope this helps : )
Can I create a union out of it? And carry out the matching entries with my data set 1 ?
Not matching somehow
Can you let me know why are we using the find replace tool?
I am using find and replace like a vlookup. I finding the names and adding column group based on the name. Search name and add its associated group to the name. Group is normalized name will be common across both data source.
Hope this helps : )