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...
  • netanel's avatar
    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!