Define tolerances

The goal of Row by Row Comparison is to confirm that the data of source row and target row match. If the rows don't match on all columns, Tosca BI considers them a mismatch.

You can, however, use tolerances to define which difference between compared values is acceptable. This allows Tosca BI to still consider source and target value a match even if there is a slight difference between them.

How do you define tolerances?

If you want to define a range from the lowest to the highest tolerated value, use one of the following formats:

  • One negative and one positive numeric value separated by semi-colon. For example: -2;+2.

  • One negative and one positive percentage value separated by semi-colon. For example: -5%;+5%.

If you want to define only a lower or higher tolerance value, use one of the following formats:

  • One negative or positive numeric value. For example: -2.

  • One negative or positive percentage value. For example: +5%.

You can not use tolerances on RowKey columns. RowKeys need to be unique and an exact match.

Specify tolerance values

You can specify tolerances for columns in the Row by Row Comparison TestStep.

To do so, follow the steps below:

  1. Navigate to General Options->Tolerances. Define your tolerances for each required column directly in the TestStepValues below.

  2. In the Name column, enter the name of the column.

  3. In the Value column, specify the tolerances as needed.

In this example, source column Product A contains the value 33.8. In target column Product B, this value can differ.

You want to tolerate a minimum target value of 31.8 and a maximum target value of 35.8.

To specify this tolerance range, you enter the value -2;+2 for the target column Product B.

Specified tolerance range of -2;+2.

Choose locale for decimal and thousand separators

Before tolerance is applied to a column, Tricentis Tosca converts the column to a number. Tricentis Tosca uses US English for number formatting. This means that comma (,) is the default thousand separator and dot (.) is the default decimal separator. You can change this locale in both Source and Target. To do so, follow the steps below:

  1. Navigate to Column Options under Source or Target.

  2. For Locale, choose a language from the drop-down menu.

    The list also includes all dialects of a language. For example, you can use the German (Liechtenstein) locale, which uses a single quotation mark as a thousand separator instead of a period.

    Alternatively, you can choose System Culture, i.e. the default locale of the system where the data resides.

Choose locale

Choose a language