No announcement yet.

Data compare, primary/secondary key columns

  • Time
  • Show
Clear All
new posts

  • Data compare, primary/secondary key columns

    I have a pair of spreadsheets that I need to compare. There are three columns. Column 3 is the primary key, and column 1 is the secondary key. In other words, I need the compare to be sorted by column 3 and sub-sorted by column 1. The values in both columns 3 and 1 must match (except for whitespace and character case differences) for the rows to be aligned. Column 2 is a normal column to be compared when the two key fields match.

    How do I get the data compare to sort by column 3 first then by column 1?

    Edit: Never mind... I figured out how to go into Session Settings and float column 3 to the top.
    Last edited by Michael Bulgrien; 09-Nov-2011, 01:22 PM.
    BC v4.0.7 build 19761