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

Using values from an excel sheet to calculate different values for further use

This article describes how to get values from an excel sheet (which is not used as a data source for templates) do calculations on those values (specifically ranges) and save them to a buffer for further use.


Situation

Sometimes, it is not possible to use an excel sheet as a direct data source for templates, but usage of data, specifically calculations based on such data is required for further testing procedures.

Solution

In such a case, you can use the Excel Engine, TC String Operations and TC Set Buffer to get a buffer with a calculated value that you can use in your further testing.

As an example, the author of this article wanted to have the minimum value of a value range present in an excel sheet on the local file system, the procedure is as follows:

  1. Excel Open Workbook
  2. Excel Create Range
  3. Buffering the contents of the range
  4. Trimming out the line separators via TC String Operation (this is important - see below why)
  5. Feeding the buffer to the CALC expression (using the "MIN" formula in Excel) in it's new form and overwriting the existing buffer value

The first two steps in this work flow are rather self-explanatory, however, after buffering the whole column, the values are separated by carriage return and line feed characters, which is why directly passing them to a CALC expression would not work (because Excel functions need a separator between their arguments) so, these characters are trimmed out using TC String Operation and replaced with a comma "," character (the separator used by Excel localized in English) before the buffer containing these values - now separated by commas - is passed to the {CALC[MIN({B[...]})]} which will then write the lowest value in that buffer into either another buffer, or the buffer where the values were stored before.

The *.zip File attached to this article contains a subset where the work flow above is showcased, as well as an example excel file to work with.

Attachments
0 0

Renuka Vasudevan

Created: 2017-04-04 10:40:35

Hi Markus,

  Can we do the same , in requirement section . Would like to add more columns with some values , and calculate a new risk weight based on the values from the other columns. Is this possible?

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial