Forum Discussion

JasonP's avatar
JasonP
Frequent Visitor
9 years ago
Solved

Removing duplicate data

I am trying to tie together multiple vendor data with our internal data. I have an accounting system that separates agents by company first, then a unique number so for instance John Smith at Company...
Need Help
  • JasonP's avatar
    JasonP
    9 years ago

    I figured it out. The main usable difference in the tables I had was an office code. I added the office code to the unique ID on both ends and was able to match. 

     

    Thank you all for your help, for future reference, how to I share sample data? My data is sensitive internal data so I don't know how to show you without posting on the web our companies internal numbers and info. 

JasonP's avatar
JasonP
Frequent Visitor
9 years ago

I figured it out. The main usable difference in the tables I had was an office code. I added the office code to the unique ID on both ends and was able to match. 

 

Thank you all for your help, for future reference, how to I share sample data? My data is sensitive internal data so I don't know how to show you without posting on the web our companies internal numbers and info. 

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago
You would need to anonymize it. As long as we can see the structure of the tables that is all we need.