Interval Match

[#1]

I have attached document and data file can anyone help in matching interval in straight table I am missing something.

I want to get grade student corresponding to Total score

[#2]

hic

[#3]

Hi,

U have different grades and different grading names for same grademax and grademin intervals. Like for example

0-50, u have F as a grade in new grading, Red in school grading and C(26-50) as a grade in old grading. I think, as u have different grades for same intervals, u should make changes in source table if I m not wrong.

[aveeeeeee7en]

Hi aamir

Try something like this:

Grades:

LOAD GradeID,

    GradeMin,

    GradeMax,

    Grade,

    GradingName

FROM

.....\TotalScore.xlsx]

(ooxml, embedded labels, table is Grading);

Scores:

LOAD StudentID,

    SectionID,

    Score

FROM

.....\TotalScore.xlsx]

(ooxml, embedded labels, table is Total);

Final:

IntervalMatch(Score)

Load

    GradeMin ,

    GradeMax

Resident Grades;

Also see the Attachment.

[#5]

thats not issue as one grading type at a time

need to do in straight table as I have to perform what if analysis too