Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2012
    Posts
    9

    Default How to stop csv data compare sorting by the first column

    I would like to see the data compare of two csv files that doesn't sort by the first column. I can't find an option to switch off the sorting, and just compare the lines in the original file order.

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

    Default

    Hello,

    By default, the first column is a Key column, and the Key is (by default) sorted and aligned by. You can disable the sorting in the Data Compare's Session menu -> Session Settings, Columns tab, enable "Unsorted alignment"
    You can also disable it as a Key if it is not by right clicking the column header and making it a Standard column. (You can also change this in the Columns tab by editing the column.)
    Aaron P Scooter Software

  3. #3
    Join Date
    Feb 2012
    Posts
    9

    Default

    Thanks. I would like to use BC for comparing test output with a reference folder. I have saved a folder level session pointing to the two folders, and a data compare session with the Unsorted box checked, and the left and right file names with the folder names and *.csv, which it accepted. When I double-click on a csv file in the folder view, how can I get the saved data session to be applied. Currently, I have to select the saved session for each file. I don't really want to change the defaults for all data compares.

  4. #4
    Join Date
    Jan 2006
    Location
    Olympia, WA, USA
    Posts
    46

    Default

    You could switch to Text Compare rather quickly.

    Session, Compare Files Using, Text Compare
    Ken Grubb
    Olympia, WA

  5. #5
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    4,759

    Default

    When you set the Data Compare settings, change the dropdown in the Session Settings dialog from "Use for this view only" to "Use for all files within parent session". This will affect all Data Compares launched from the same parent Folder Compare session, but it won't change the default for comparisons outside of that folder compare.
    Chris K Scooter Software

  6. #6
    Join Date
    Feb 2012
    Posts
    9

    Default

    Thank you Chris - exactly what I needed.

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
  •