Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2017
    Posts
    2

    Default Is there a way to exclude columns from data compare report?

    We have used data compare to compare a 50M file size pipe delimited text file with 100,000 rows. Some records in the file has large text in a column, the side-by-side text report created by BC with 10,000 rows difference has file size about 1G. That is 20x bigger than the original file. Is there a way to exclude the column from the report?

  2. #2
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    12,005

    Default

    Hello,

    Not in an automated method, but in the interface you can right click any Column Header to set as Key, Standard, or Unimportant. If you make this column Unimportant, you can hide any rows where it is the only difference. You can also Hide Column from view to remove it entirely. After either or both of these is done, you can then generate the report from the Session menu.

    If you need to always remove the column from view, it may be recommended to create an External Conversion (program or script) that alters the file and exports to a temporary file that is missing this information. This is similar to how we tidy or sort files. The temp files would then be the files compared (and wouldn't need to alter the view, since the temp version would lack the extra data). For an example of a conversion, we have a KB article here:
    http://www.scootersoftware.com/suppo...rnalconversion
    Aaron P Scooter Software

  3. #3
    Join Date
    Jul 2017
    Posts
    2

    Default

    Thanks Aaron. Your help is much appreciated. I can use the <HiddenCols Value="..."/> in the exported session xml.

  4. #4
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    12,005

    Default

    Ah, yes. If you are comfortable editing the BCSessions.xml directly, you can alter the default settings we would load before launching BC4. Then launch and run your script.

    It may help to use a Portable Install (the setup.exe wizard can create) for this type of deployment. That way, the BCSessions.xml is always located within the install directory, no matter which Windows User account runs the application. Just be sure to install to a location that any Windows User can have write access (such as C:\Tools\Beyond Compare 4\) so that using the application allows writing to the settings .xml files in the directory.
    Aaron P Scooter Software

Posting Permissions

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