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

Need Help

v-frfei-msft

Community Support

6 years ago

Hi Anonymous ,

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

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?
  - Anonymous
    Not applicable
    6 years ago
    I think my company is restricting access for those in different domains. Try with this:
    
    https://drive.google.com/file/d/1RjrvyNkHnxafH1ZN3f-zsapOJ11R0_7s/view?usp=sharing
    https://drive.google.com/file/d/1wrBanQcFN8o8wbQ36uxvJaGft37Ephgj/view?usp=sharing

Forum Discussion

Matching Records

Related content

How to apply Slicer filter on un-matching record between two different table.

How to Count from two different table Un-matched record with New table

Counting Non-Blank Records

Sorting Records

Eliminate duplicate records while keeping the most recent record.