Help get this topic noticed by sharing it on Twitter Twitter, Facebook Facebook, or email.
Lars
indifferent I’m interested in finding a solution
Lars November 16, 2010 09:12

How can I compare records in DQA?

Hi,

I would like to find records that do not follow certain rules. I need to find the records with the same id und compare their date. There is one column, which gives the beginning of an interval and for the end. The questions is, if these periods are coherent for records with the same id.

How can I find an expression fot this problem?
Are business rules the best way to arrange this comparsion?

regards
1 person has
this question +1
Reply

  • Pavel Nejedly EMPLOYEE
    Pavel Nejedly (Official Rep) November 18, 2010 14:52
    Hi Lars,

    Thanks for the question. Unfortunately, this type of analysis (finding out whether a set of intervals has no overlaps and no gaps) is not possible in DQ Analyzer alone, but it's possible in Data Quality Center.
    The problem is in the fact that DQ Analyzer is missing any multi-row operations (except for the foreign key analysis). What you need here is actually a suitable sorting of the data and joining each interval to the following one.

    Pavel
    Comment
    good answer! good answer! (undo)
  • (some HTML allowed)
    How does this make you feel?     Add Image
    I'm

    e.g. indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited sad, anxious, confused, frustrated

    Cancel