Comparing two files

[netanel]

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

[netanel · Accepted solution]

@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!

[v-yiruan-msft]

Hi @netanel ,

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

Best Regards

[v-yiruan-msft]

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