Data Reviewer: How to compare double type attribute values with tolerance?

2639
0
07-18-2013 04:04 PM
SuiHuang
Occasional Contributor II
Hi Everybody:

    I am building a data reviewer check to identify data issues by comparing double values. I am using "Table to Table Attribute Check" for this task.
   
    Ideally I want to findout all the features in class 1 violating (Class1.Code=Class2.Code AND Class1.Attr<=Class2.Attr), given that Class1.Code=Class2.Code is already satisfied by a previous sub-check in the same composite check.

    However, the conditions such as (Class1.Attr>Class2.Attr) or (NOT Class1.Attr<=Class2.Attr) does not support tolerance. For example, if Class1.Attr=100.0001 and Class2.Attr=100, the check will report error, but that can be considered a false alarm...

    Is there any way to check double values with tolerance?

    Thank you!
Tags (2)
0 Kudos
0 Replies