Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2017
    Posts
    1

    Default Rows are missing from on Beyound compare while doing data compare my saved excel shee

    I have data extract from my SAS database and save it as excel file with rows count of 12003 and also extract the same file name from my Linux box as a text file with pipe value.


    Under beyond compare all the rows and column are matching between two files. The only problem is the beyond compare has missing rows


    Any idea why!

  2. #2
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    11,997

    Default

    Hello,

    In the Table Compare, are your Display Filters currently set to Show All or one of the other filters?

    If you are still having trouble, would it be possible to email into support@scootersoftware.com with:
    -a sample file
    -a screenshot showing the Row Numbers and the problem row
    -a link back to this forum thread for our reference

    Another quick test is to use your copy of Excel to Save As CSV or Tab Delimited, verify that export, and then open the temp file(s) in BC4, to see if there's an issue with the conversion or the comparison that's hiding the rows you expect.
    Aaron P Scooter Software

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •