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

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