Announcement

Collapse
No announcement yet.

10721 Data Compare non-alignment

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 10721 Data Compare non-alignment

    How can I get Data Compare to align similar lines e.g. lines 3492 here:

    http://img143.imageshack.us/img143/954/29830220.gif

    ?

    They differ in just five chars in column one.

    Thanks.

  • #2
    The Data Compare requires at least one key column to be defined. The Key column(s) must match exactly for the rows to then align.

    There is no way to align 'similar' key columns in the current version. This is already on our wishlist.
    Aaron P Scooter Software

    Comment


    • #3
      > There is no way to align 'similar' key columns in the current version.

      OK.

      > This is already on our wishlist.

      Thanks.

      Comment


      • #4
        Originally posted by chrisjj View Post
        How can I get Data Compare to align similar lines...
        Right-click on the column headers. Set one or more other columns as "Key Columns" then set column 1 as a "Standard Column".
        BC v4.0.7 build 19761
        ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

        Comment


        • #5
          Thanks Michael - I chose an empty column for the only key, and that worked fine.

          Comment


          • #6
            That should work for you.

            Technically, a Key be definition should be unique, but we do not enforce that in Beyond Compare. If a key matches, then it will align.
            Aaron P Scooter Software

            Comment


            • #7
              > If a key matches, then it will align.

              That workaround fails me today:



              Any idea why?

              Comment


              • #8
                What failed? You have key columns defined as 1 and 11. Column 1 keys do not match due to the "track not found" errors on the right side. All key columns must match for data to align.
                BC v4.0.7 build 19761
                ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

                Comment


                • #9
                  Whoops, sorry, I'd assumed that setting key=#11 would clear #1 and had failed to notice it did not. Nice that BC does allow multiple keys...

                  Thanks M.

                  Comment


                  • #10
                    Thanks, Michael.

                    And yes, BC allows multiple columns to be set as a Key. The combination of the columns then must be what is unique and identifying.
                    Aaron P Scooter Software

                    Comment

                    Working...
                    X