Skip to main content

Compare Tools

If you work with data on a daily basis, there will inevitably be situations where you need to compare two or more datasets to identify differences, similarities, or emerging trends. Brobench provides robust comparison tools that make this process simple, accurate, and efficient.

With just a few clicks, you can align datasets, highlight discrepancies, and visualize patterns — saving significant time while ensuring data integrity and informed decision-making.

These features are available in the Professional Edition. Note that there is also Compare Data module which allows you to compare any two data sets between orgs or CSV files.

There are three compare tools in the Datagrid.

  • Compare Records: Compare Records allows you to compare any two records or two datasets between two query data grids
  • Compare Values: Compare Values allows you to compare any two values in the datagrid or with clipboard
  • Compare Fields: Compare Fields allows you to compare two fields in the same record.

Compare Records​

Compare Records allows you to compare any two records or two datasets between two query datagrids.

Compare Two Records​

In the Query Datagrid (or any other Datagrid for that matter), select two records. You can select rows by clicking on a row and dragging down or up. You can also use Ctrl+Click/Cmd+Click to select rows which aren’t next to each other.

Once you’ve selected two records, Right-Click -> Compare -> Recors with Each Other.

App will show the below dialog highlighting the differences between the two records. Please refer to Compare Data module how to use the controls in the dialog as both share the same UI.

Compare Records Between Two Datasets​

Let's say you want to compare between two Query Datagrids or in the same Query Datagrid, compare two datasets would be helpful.

  • Step 1: Select the source dataset by selecting one or more records in any datagrid.
  • Step 2: Right-Click -> Compare -> Set as Compare Records Source
  • Step 3: Go to the target datagrid or same datagrid where you want to compare the source dataset and select one or more records.
  • Step 4: Right-Click -> Compare -> Compare Records with Source

Make sure you select the appropriate Key Field to compare the records by. You can also select to ignore one or more fields.

Compare Values​

Compare Values allows you to compare any two values in the datagrid or with clipboard. This is most useful if you have long text field, and you want to compare values across two records or with different long text fields in the same record or with clipboard.

Compare Two Values​

Select any two cells in the Datagrid, and then Right-Click -> Compare -> Values with Each Other.

Then app shows the below dialog comparing two values.

Compare Value with Clipboard​

Let's say you want to compare the value in a cell with some text that you’ve copied from elsewhere (email or web page). In such cases, Compare Values with Clipboard would be helpful.

  • Step 1: Copy the text you want to compare with to clipboard.
  • Step 2: In the Datagrid, select the cell you want to compare with the clipboard.
  • Step 3: Right-Click -> Compare -> Values with Clipboard

App will show the same dialog as the previous section

Compare Fields​

Compare Fields allows you to compare two fields in the same Record. This feature also has capabilities to help review a set of records, mark a record for further actions.

Real World Example

A client had inadvertently stored credit card information within Case Description fields. To comply with PCI DSS regulations, they needed to remove all sensitive data. To achieve this, the team created a secondary field on the Case object to store the scrubbed version of the Description.

Next, they needed to verify that the original and scrubbed Descriptions matched as expected. Using Compare Fields, they quickly reviewed both versions side by side, identified discrepancies, and marked records requiring further action. Finally, they exported the flagged records for additional review and compliance processing.

To access this feature, go to any Datagrid, Right-Click -> Compare -> Fields in Record. App will show the below dialog.

Select Source and Target Fields: The important thing to do in the Compare Fields dialog is to select the Source Field and Target Field you want to compare. Once you select the fields, app will show the comparison between the two fields for the current record.

Navigate Between Records: You can use the navigation buttons at the top left to navigate between records in the datagrid. As you navigate, app will update the comparison between the two fields for that record.

Flag Records for Further Action: If you need to identify records that require further action, you can use the Mark button (flag icon) at the top right. When you click the flag icon, the app will add the current record to the Flagged Records list and goes to next record.

Click on the Dropdown next to Flag Record icon to show below menu.