Forum Discussion
Data mapping from 3 different sources.
Hi lbendlin ,
Thank you for your reply.
Good question. I don't have too much knowledge on this subject. When trying to play around with dummy data, I used Fuzzy matching in PowerQuery and Fuzzy Lookup with a similarity value of 0.8. From what I observed, for example, the name Google Inc and Google were matched as similar in both approaches.
From what I've figured out Power Query in Excel uses the Jaccard Index algorithm, will it be suitable?
I am also concerned with the step-by-step approach to the problem?
Is it worth merging the 3 data sets into one or keeping them in separate tables and doing comparisons?
What would you advise in such a situation?
My setup for Fuzzy Matching i PQ.
How do you decide which of the tables has the "authoritative" value? Or do you just want to end up with similarity groups?
I think the authoritative board will be the Microsoft board and to that I will try to map my company and company B's data.
I understand enough that I need to somehow match in one line the relevant data for one company. So that from these 3 sources the data will be the same based on the different key. And this is pretty much where my understanding of the approach to the subject ends. The data I got looks much more complicated than that. There are dozens of columns in one file. I see only 2 keys that are common to these 3 files.