This site requires JavaScript to be enabled
IE BUMPER

Logo

Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

How to compare xlsx or xls files using Row by row comparison Module in BI

How to compare xlsx or xls files using Row by Row comparison Module in BI


Situation

Xlsx or xls files are not supported in row by row comparison module directly, you can either convert them to CSV files and then use them.
Another method is to install an ODBC driver for excel and use either the DSN or the connection string to compare.

PLEASE NOTE: You will need Tosca BI-Licenses to do this Excel comparison.
 

Solution

Step 1.
Install an ODBC dirver for Excel using the below link
(Please note that the driver needs to be for the Excel Version you want to steer)

https://www.microsoft.com/en-us/download/details.aspx?id=39358

 

Step 2.
Create an ODBC connection pointing to the Excel File you want to compare. For the second Excel File you can create another ODBC Connection.

 

Step 3:
For this approach, DO NOT USE the "DSN" TestStepValue even though you just created one.
Instead, use the ConnectionString TestStepValue.

You have two ConnectionString possibilities:

"Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};Dbq=<Filepath to xlsx>;"

Either you mention the Drivername and the path to the File inside the Connectionstring.
With this approach, you only need to alter the Path inside the ConnectionString, you do not need to create ODBC Connections with this.

OR

...you mention the DSN Name of the ODBC Connection and the path to the File.
Please note: Since your ODBC Connection points to one specific Excel file, you will need an ODBC Connection for every Excel file you want to compare. 

"DSN=<DSN Name>;Dbq=<Filepath to xlsx>;"

 

 

The differences will be shown in HTML or CSV based on your selction in error reporting.

Reference

Microsoft Driver : https://www.microsoft.com/en-us/download/details.aspx?id=39358

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial