Forum Discussion

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...

Community Support

6 years ago

Hi Anonymous ,

In your scenario, you should switch the Join kind to Right join as the picture below.

Anonymous
Not applicable
6 years ago
Hi Frank, v-frfei-msft

didn't change much :(
v-frfei-msft
Community Support
6 years ago
Hi Anonymous ,

Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
- Anonymous
  Not applicable
  6 years ago
  Hi Frank v-frfei-msft
  
  I gave you the 2 files, either way, I should try to get to the same result, it's just two alternative ways of doing it:
  
  https://qantas-my.sharepoint.com/:u:/r/personal/albertobartozzi_qantas_com_au/Documents/Benchmark%20tool/New%20Fare%20Grids%20V2.pbix?csf=1&e=pnBTEd
  
  this is the one we're talking about
  
  https://qantas-my.sharepoint.com/:u:/r/personal/albertobartozzi_qantas_com_au/Documents/Benchmark%20tool/New%20Fare%20Grids.pbix?csf=1&e=dxAr9d
  - 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?