![]() From my experience, it just sometimes works out a little easier this way. If you wanted to actually see what duplicates were detected and removed by Excel, you could always compare the "combined" file from both before and after removing the 'dupes' in Excel against one another in a diff tool. If youre interested, here is the jq command I wrote to sort the JSON by medication name: jq '. If all you wanted was to end up with a properly merged/combined list - you're done after the 'remove duplicates' maneuver, with alot less fuss and manual effort than dredging through the original files directly in a diff tool. The reason is because WinMerge doesnt understand that each array item in JSON file 1 needs to be compared to the matching array item in JSON file 2. For something like this particular example, I'd probably not even bother using a visual diff tool at all (I use Araxis Merge) and would most likely resort to just creating a third file with the contents of BOTH of the 2 original files you have now, and then just run Excels built-in (at least as of Office 2007/2010) remove duplicates function/macro/button/whatever. but still, with sooooo many addresses you could still end up with quite alot of manual clicking and what-not. You could certainly "sort" each file first to cut that down alot I'm sure. ![]() Duplicate entries might not even be identified by many of the diff tools out there if the duplicate addresses are very far apart from each other relative to where they appear in each of the files. that's a huge number of differences to compare visually, depending on how they're sorted. ![]()
0 Comments
Leave a Reply. |