Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
netanel
Post Prodigy
Post Prodigy

Comparing two files

Hi everyone,
I have two tables that come from two different files
The names of the columns are different but their sum or count should be the same.
In the parameter I compare the different amounts
My question is this
How do I flood the difference between the tables in a smart way

Link to File:

https://1drv.ms/f/s!AonyYI-TdspHgUhwngZ6OKvpnSsc

 








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki
1 ACCEPTED SOLUTION
netanel
Post Prodigy
Post Prodigy

@v-yiruan-msft 

Hi Thanks,
I found a relatively convenient solution
1. I collect the files and arrange them in structured tables
2. Export to Excel
3. Picks back up
4. Uses the EXCEPT function
5. Exports only the changes

 

Thanks!








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

View solution in original post

3 REPLIES 3
netanel
Post Prodigy
Post Prodigy

@v-yiruan-msft 

Hi Thanks,
I found a relatively convenient solution
1. I collect the files and arrange them in structured tables
2. Export to Excel
3. Picks back up
4. Uses the EXCEPT function
5. Exports only the changes

 

Thanks!








Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!

Connect on Linkedin
linkedin.com/in/netanel-shriki

Hi @netanel ,

It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Thank you.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yiruan-msft
Community Support
Community Support

Hi @netanel ,

It seems that I have no sufficient permission to access the shared file. Could you please grant me the proper access? Thank you.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.