Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Matching Records

Hi Community people,   i'm trying to merge 2 datasets with a common field created on purpose: these 2 datasets have the same information but classified differently, hence I created this common fiel...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Sorry I canot access the files by your link. Could you please check and share again?

 

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Based on my test using part of your data. I can get all columns by mergeing queries. Please check the attached pbix and source files. You can update the file path in Power query and view the M code.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-frfei-msft Frank, 

      sorry for such a late reply but I had to wait until my laptop got replaced with Windows 10 as PBI was unstable with Windows 7.

      Coming back to this, it perfectly matches if we merge with QF DATA, but 0 merges with VA data.

       

      the coding query is the reference of QF DATA without all columns but coding. I also try to split this as a new source but when it comes to merge with VA data, 0 matches

       

      any idea why?