1 / 4

Finding Differences Between Large Files

Learn how to find differences between large files using Norton Compare, Excel, and field extraction techniques. Compare GMI updates with current marriages, extract fields, merge data, and eliminate identical records. Exercise included.

catherinem
Download Presentation

Finding Differences Between Large Files

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Finding Differences Between Large Files Gordon Adshead 9Aug08

  2. Finding Differences • Demonstrate Norton Compare • Using Excel to compare GMI updates

  3. Comparing GMI with Current Marriages • Extract Fields from Current Marriages • Put GMI and Current into same fields • Add Field 1 <old> <new> and merge • Concatenate All Key Fields • Sort on Concatenated Fields • Add 2x IF expressions • Eliminate Identical records

  4. Exercise • Find the differences between GMIBBB.xls and GMICCC.xls

More Related