6 Replies Latest reply: Aug 13, 2015 8:40 PM by arjun rao RSS

    Understanding the rules of Interval Match function, value and range must be loaded first?

    John Blomqvist

      Hi all,


      I am trying to understand how to use Interval Match function.


      For example I have a Student Grades table with StudentID, CourseID, Grade.


      I would like to compare the Grade value against Grade Range.


      Grade Range is in the GradeRange table with CourseID, GradeStart, GradeStop, Range as fields.


      In order to do Interval Match is it true that I must have those two tables created first to do the analysis?


      So my intervalmatch table would be:



      Load GradeStart, GradeStop Resident GradeRange;


      Can the Load table after IntervalMatch have more than two fields?