Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2018
    Posts
    2

    Post How to insert empty rules in a file compare - comparing 2 xls files

    Hi all,

    I'm not an experienced used - but perhaps you can help me out....

    I'm comparing 2 different excel sheets - using the File Comparison.

    I would like to insert empty white rules because in both the left- as right screen. Because when I have a missing rule in e.g. number 3 - all the lines after rule number 3 while be picked seen as differences.
    Therefore I would like to be able to insert an empty rule in e.g. the right screen to do further comparisons.
    I assumed the I could INSERT an empty line - however this option is greyed out.

    Many thanks for your help and answers in advance! Really appreciate it!

    Best regards,

    Robert

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

    Default

    Hello,

    BC4's Table Compare view for Excel (.xlsx) files is read only, and cannot be edited, but we can alter the view to re-arrange the columns for comparison.

    This is found in the Session menu -> Session Settings, Columns tab. Here you can 'move' the columns around to tell which should align with which. Does this help push the columns up by one, so everything aligns again like you need and compares like you expect?
    Aaron P Scooter Software

  3. #3
    Join Date
    Jan 2018
    Posts
    2

    Default 2nd question with regards to table compare

    Hi Aaron,

    Many thanks for your answer! I tried your sollution and this parially helps out!
    I'm trying to do the following things comparing 2 excel sheets and don't know if this is possible in BC.
    > Insert blank rules in the right or left screen to skip a rule (e.g. for a missing rule in one of the xls sheets)
    > Insert a unique key (e.g. by entering a trim function of for example A+B+C+D+E)

    Hope that you are able to help out! Your help and assistance is much appreciated!

    Thank you,

    Robert




    Quote Originally Posted by Aaron View Post
    Hello,

    BC4's Table Compare view for Excel (.xlsx) files is read only, and cannot be edited, but we can alter the view to re-arrange the columns for comparison.

    This is found in the Session menu -> Session Settings, Columns tab. Here you can 'move' the columns around to tell which should align with which. Does this help push the columns up by one, so everything aligns again like you need and compares like you expect?

  4. #4
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    11,788

    Default

    Hello,

    You can re-arrange the column alignment in the Table Compare's Session menu -> Session Settings, Columns.

    Here you can also select and set specific columns as Key. The combination of every Key column forms the whole Key. From the main compare display view, you can also right click the column header and set it as Standard, Unimportant, or Key, so you can set Keys here, too.
    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
  •