Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2016
    Posts
    1

    Default CSV comparison weirdness

    Hi,
    I have 2 very similar CSV files, but without headers in the first row (just a matrix of numbers). The second has zeros for the last, say, 10 rows (out of 40 total). I would expect when doing a comparison that the last 10 rows would show up as red, but it actually reorders my rows in the view and it looks like the two files have had their rows shuffled!

    Image showing BC4 screengrab attached.
    Is there any way that we can sort this out? Thanks.
    Attached Images Attached Images

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

    Default

    Hello,

    The Table Compare's default alignment uses a defined Key and sorts by this key. Sorting can be enabled/disabled in the Session Settings dialog, Columns tab: Unsorted Alignment toggle.

    If there is no defined Key, then the entire Row is the alignment key. You can mark any column as a Key by right clicking the header in the main view, or updating the column settings in the Session Settings, Columns tab. With a Key defined, that is the only value(s) sorted. You can mark multiple columns together to act as a Key. Is there a Key within your structure that you could use?
    Aaron P Scooter Software

Tags for this Thread

Posting Permissions

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