• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Detailed data comparison

You can compare data in 2 selected tables or views so you can exactly know, which data cells have different values.

  1. Create a new project or open an existing one.

  2. Select the operation scope by choosing the desired nodes on metadata trees.

  3. Click Compare in Detail button in the Data Operations panel. You will get to the matching page.

    Here you can adjust objects matching if needed.

  4. Click the Maximize button to see the operation details in the fullscreen mode.

  5. Click the Options button at the bottom right-hand corner of the central window. You will get to the Data comparison options page.

  6. Click the Sorting keys button at the bottom right-hand corner of the central window to proceed the operation. You will get to the Sorting keys selection page.

  7. Click the Run button at the bottom right-hand corner of the central window to get the result.

    As a result, you’ll see all different values in two tables or views.
    If you just need to get sure that two tables are equal (have no differences), go to the simpler Data comparison operation or use the Fast data comparison operation.

  8. If you can’t clearly see the differences in this table, double click on the selected line to open a ‘Detailed row comparison’ window.

    As a result, you’ll see all different values in two tables or views.

  9. Click the Export button at the bottom right-hand corner of the central window to save the comparison result into the .csv file.

  10. Click the Close button at the top right-hand corner of the central window to close the Data comparison window.