Hello karuppasamy,
Interval match is used to match the numeric values.
suppose.,
if you take a..data like this,
Grade Table:
load * inline [ Grade,Start,End
fail,0,39
D,40,49
C,50,59
B,60,69
A,70,79
A+,80,100 ];
and
Marks Table:
load * inline [ Marks,SId
9,101
20,102
31,103
45,104
50,105
61,106
76,107
82,108
90,109
99,110 ];
without using any interval match function is going to get result like this:
without interval match is going to assign the all grades for each and every student in that list like below,
Result:(without interval match) :
Marks,SId,Grades
9,101,fail
9,101,D
9,101,C
9,101,B
9,101,A
9,101,A+
20,102,fail
20,102,D
20,102,B
20,102,C
20,102,A
20,102,A+
31,103,fail
.
. .
31,103,A+
45,104,D
50,105,C
61,106,A
76,107,C
82,108,B
90,109,C
99,110,fail..................
in this type of scenarios we can use interval match function to get better and correct results.
IntervalMatch(Marks)
Load
Start,
End
Resident Grades;
Here..from our example Marks is the dimension which is changing ...toward the students,
based on the student performance marks are going to change for every one..because
we are applying interval match function to the marks dimension,
based on start and end marks from Grades table.
then it is going ti give the correct result as fallows:
Result:(with interval match)
Marks,SId,Grades
9,101,fail
20,102,fail
31,103,fail
45,104,D
50,105,C
61,106,B
76,107.A
82,108,A+
90,109,A+
99,110,A+
and
if you have any scd you can apply interval match.
Thanq.
