Interval Match

[qlikview979]

Hi Experts,

Please find the Attached files.

How Can i use interval match in this  two tables.

Maxmarks	Minmarks	Name
90	80	Raj
80	70	Raja
70	60	Varun
60	50	Venkat
50	40	Arun

Marks	Grade
85	A
75	B
65	C
55	D
45	E

[ajsjoshua]

Hi,

PFA

[ajsjoshua]

Hi,

table:

LOAD Name,

     marks

FROM

E:\Joshua\sample\intervalmatch.xlsx

(ooxml, embedded labels, table is Sheet1);

table2:

LOAD Grade,

     maxmarks,

     minmarks

FROM

E:\Joshua\sample\int1.xlsx

(ooxml, embedded labels, table is Sheet1);

bridge:

IntervalMatch(marks)

LOAD maxmarks,minmarks

Resident table2;

[MK_QSL · Accepted solution]

Marks:
Load * Inline
[
  Maxmarks, Minmarks, Name
  90, 81, Raj
  80, 71, Raja
  70, 61, Varun
  60, 51, Venkat
  50, 40, Arun
];




Grade:
Load * Inline
[
Marks, Grade
85, A
75, B
65, C
55, D
45, E
];


Left Join 
IntervalMatch(Marks)
Load Minmarks, Maxmarks Resident Marks;


Left Join (Marks) Load * Resident Grade;


Drop Table Grade;

[MindaugasBacius]

Intervals:
LOAD Maxmarks, 
     Minmarks, 
     Name
FROM

(ooxml, embedded labels, table is Sheet1);


Data:
LOAD Marks, 
     Grade
FROM

(ooxml, embedded labels, table is Sheet2);


IntervalMatch (Marks) LOAD Minmarks, Maxmarks Resident Intervals;

This might work.

[kkkumar82]

Hi Mahesh,

Beginners Task Series - Task3(Interval Match)

Hope this helps

[qlikview979]

Hi All,

Thanks for your Support.

Regards,

Mahesh.