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 ,

 

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's avatar
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