I’ve done an automation that compares two separate Excel files sheet by sheet and then reports the uncommon/changed rows. It works fine with most files that I’ve given to it, but now for some reason it reports all rows for one particular Excel - even though there are only four rows that actually have differencies. What could be the reason for that? I’ve browsed all forum threads on comparing datatables and tried all different approaches, but every time the outcome is the same. Please help!
@Anil_G Thank you for your time to reply to me. I can’t share it as it’s confidential data, but it’s basically text and numbers. I’ve compared the data from datatables in debug mode and I can’t see any visible difference in it.