LogoLogo
23.2 - Veeva Vault Edition
23.2 - Veeva Vault Edition
  • dqMan Veeva Vault Edition Overview
  • Legal Notice
  • Release Notes
  • Licensing
  • Connecting to Veeva Vault
  • Vault Navigator
    • Documents
    • Objects
    • Handling Picklists
    • Favorites Panel
    • Local tables
    • Object Navigator
  • Session Window: VQL, MDL
    • VQL View
    • MDL View
    • dqMan Proprietary Statements
  • VQL Execution History
  • Favorites
  • Dumping Objects
  • Search Function
  • View Textfiles
  • Import Data to dqMan
  • Compare Data
  • Customize dqMan Veeva Vault Edition
  • Third Party Open Source Libraries
Powered by GitBook
On this page
  • Comparison Tool
  • Overview
  • Key Features
  • Flexible Boolean Field Comparison
  • The Object Compare List

Was this helpful?

Export as PDF

Compare Data

Last updated 1 year ago

Was this helpful?

There are two ways to compare data:

  • The function from the Extras menu enables you to compare different data lists, for example DQL query results with other VQL query results or with imported data lists.

  • The enables you to add single objects of any type, from any repository. These objects are compared attribute by attribute and you can modify them directly in the list.

Comparison Tool

Overview

The Comparison Tool is a feature-rich utility designed to compare data from different sources, such as DQL query results, imported data lists, or clipboard data. This tool provides flexible options for comparing only the rows that differ between datasets, and it supports various combinations of comparison criteria.

Key Features

1. Data Sources

  • The Comparison Tool requires at least two open data lists for comparison.

  • Data lists can be results from DQL queries, imported data lists, or data from the clipboard.

2. Comparison Options

  • Different Rows Only: Compares and displays only the rows that differ between the two datasets.

  • Left-Only Rows: Displays rows present in the left dataset but not in the right dataset.

  • Right-Only Rows: Displays rows present in the right dataset but not in the left dataset.

  • Equal Rows: Displays rows that are identical in both datasets.

3. Column Configuration

  • Columns with matching data are automatically identified and displayed.

  • Users can hide or unhide columns for comparison based on their preferences.

  • Double-clicking on a selected column removes the association for that column.

  • The "join" function enables the selection of columns for matching comparisons, while the "compare" function is utilized for specifying the columns intended for comparison

  • The case-sensitive option can be toggled on or off prior to initiating the comparison.

  • The match button automatically performs the matching process for both the join operation and the columns earmarked for comparison, eliminating the need for user selection. Unnecessary columns can be excluded from the context menu before the comparison.

4. Automatic Refresh

  • The data in the grids is refreshed automatically when the source data changes. This ensures real-time updates during active comparisons.

5. Visual Indicators

  • Columns with differences are visually highlighted in a distinct color in the header.

  • Identical columns are displayed in the normal color.

6. Date Format Configuration

  • Accepted date formats for comparison can be configured in the Options.

  • A set of default date formats is preconfigured for convenience.

  • The tool automatically detects the date format for columns from CSV based on the first 10 rows.

  • Detected date formats are applied to all date fields for consistency.

  • The Date/Time formats can be configured in the Options/Compare Data.

7. Handling Invalid Dates

  • If a date value cannot be converted to a valid date using the detected format, the value displayed in the grid will be "Invalid date."

8. Synchronize with Veeva

  • In cases where disparities exist between the results exhibited in Veeva and a CSV/Excel file employed by the user, the user has the capability to update and synchronize the modified data with the pre-existing data in Veeva. It is important to note that the update process is unidirectional, allowing modifications solely from the user's data to Veeva, with no reciprocal update.

  • The updating procedure can be executed directly from the compare window by utilizing one of the designated update buttons. Within the update window, all columns are presented, with those necessitating updates marked with an "update" status. Additionally, users have the option to generate a backup file from this window, serving as a safeguard in the event a return to the initial values is desired.

Flexible Boolean Field Comparison

Overview

The system offers flexible Boolean field comparison to cater to user preferences. This feature allows users to configure accepted Boolean values within the Options, ensuring compatibility with diverse input styles. The default accepted values are '1', 'Yes', 'True', '0', 'No', and 'False'.

Default Accepted Values

The default Boolean values recognized by the system are as follows:

  • True/False

  • Yes/No

  • 1/0

More values can be added in in the Options/Compare Data.

User Expectations

As a user, you can expect the following behavior in Boolean field comparison:

  1. Flexible Interpretation: Values such as '1', 'Yes', and 'True' are treated as "true", while '0', 'No', and 'False' are treated as "false".

  2. Case Insensitivity: The comparison for Boolean values is case-insensitive. Whether entered in uppercase, lowercase, or a combination, the system interprets the values consistently.

  3. Handling Unconvertible Values: If a value cannot be converted to "true" or "false", the system retains the original value and displays it as is. This feature helps users identify and rectify invalid input.

  4. Support for Default Values: The Boolean comparison works seamlessly with any of the supported default values, providing a reliable and user-friendly experience.

The Object Compare List

In the Object Compare List you can add single objects of any type, from any vault, for example a demo object from vault A could be compared with a demo1 object from vault B.

To add objects from the VQL query result list, call the Add to Compare List function from the context menu. There can be only one Object Compare list. All objects will be added to the same list which is automatically created when the first object is added. Closing the list removes all objects.

The attributes are aligned vertically. The object in the first column is the master object. All other objects are compared to the master object and differences are highlighted. Differences in single values of repeating attributes are displayed in red font color.

To change the master object, drag the new master object to the first column. If different object types are compared, attributes that are invalid for the object type remain grey and empty.

You can refresh the values of a column and remove an object from the comparison.

The context menu of the list offers additional functionalities, as follows:

Functionality
What It Does

Edit

You can modify the values directly inside the table. A change is stored only after pressing Enter. You can modify repeating attributes inside a small sub-grid, which provides its own context menu for inserting, deleting or reordering values of the repeating attribute.

Copy

Copies all selected cells into the clipboard.

Dump Object

Dumps any valid object ID in the selected cell.

Goto…:

Searches for attributes in the list.

Show Attributes

All: Displays all attributes of all object types in the list. Master: Displays all attributes of the master object. Type specific: Displays type specific attributes of the master object type only. Identical values: Displays all attributes with identical values in every column. Different values: Displays all attributes with a different value in any column.

Compare settings

Compare case sensitive: Compares case sensitive. Exact order of repeating attributes: Repeating attributes can have the same values, but in different order.

Order Attributes by

Name: Sorts attributes by name Category: Sorts attributes by category, such as an object dump Not sorted: Attributes are displayed in content server generated order.

Synchronize with master

This functions enables you to copy values from the master object to compared objects. If any range of values is selected within the area of compared objects, all selected attributes (lines) will be copied to all selected objects (columns) of the list.

In dqMan Veeva Vault Edition Edit, Synchronize with master and Dump Object work on documents only.

Normally, you can only add one instance of an object to the list. If an object is sent to the list a second time, the list entry is updated without adding the object a second time.

Sometimes it is useful to follow the changes of an object throughout its process. Therefore, you can freeze an object by clicking the button in the header of the object.

You cannot update or modify frozen objects.

Comparison Tool
Object Compare List
Comparison Tool
Columns Data Options
Update/Synchronize Columns Window