maybe you are looking for something like this:
// load min and max ranges with data. Use qualify to create table specific fieldnames.
QUALIFY*;
table1:
LOAD * INLINE [
minbandwidth, maxbandwidth , VC3 , VC4 , VC4c4 , VC4c16 , VC4c64 , VC11 , VC12
40 , 56 ,2 , , , , , ,2
63 , 74 , , ,5 , , , ,1
70 , 80 , , , ,6 , , ,3
75 , 78 ,5 ,2 , , , , ,
];
UNQUALIFY*;
// load objectname data in a temporary table
table2_temp:
LOAD * INLINE [
OBJECTNAME , bandwidth , VC3 , VC4 , VC4c4 , VC4c16 , VC4c64 , VC11 ,VC12
545 ,73 ,- ,- ,- ,- ,- , ,1
454 ,50 ,2 ,- ,- ,- ,- , ,1
566 ,656 ,5 ,4 ,
];
// load interval match
Left join(table2_temp)
Intervalmatch(bandwidth)
LOAD [table1.minbandwidth], [table1.maxbandwidth]
RESIDENT table1;
// no synthetic key
Left join (table2_temp)
LOAD * resident table1;
drop table table1;
// show remarks if there is a match
Matches:
LOAD
OBJECTNAME
, bandwidth
, VC3
, VC4
, VC4c4
, VC4c16
, VC4c64
, VC11
, VC12
, IF(VC12=table1.VC12, 'Matching') AS Remarks
Resident table2_temp
WHERE VC12=table1.VC12;
// load object name data again
Facts:
LOAD * INLINE [
OBJECTNAME , bandwidth , VC3 , VC4 , VC4c4 , VC4c16 , VC4c64 , VC11 ,VC12
545 ,73 ,- ,- ,- ,- ,- , ,1
454 ,50 ,2 ,- ,- ,- ,- , ,1
566 ,656 ,5 ,4 ,
];
// left join remarks data
LEFT JOIN (Facts)
LOAD
OBJECTNAME
, Remarks
Resident Matches;
drop table Matches;
drop table table2_temp;
