Forum Discussion
Data mapping from 3 different sources.
Hi Experts, I come to ask if it is possible to achieve data mapping in PowerBI. Currently the team is doing this in excel. This is a description of my task: Mapping of Microsoft master data to o...
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.