Forum Discussion

netanel's avatar
netanel
Post Prodigy
3 years ago
Solved

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

 

Need Help
  • netanel's avatar
    netanel
    3 years ago

    Anonymous 

    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!

3 Replies

  • netanel's avatar
    netanel
    Post Prodigy
    3 years ago

    Anonymous 

    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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi netanel ,

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

      Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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