Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
IntervalMatch - Two matching colums
The following script is not working in terms of matching correct data. can you please give me the reasons. The sample code is as follows
Basically i want to match x, y coordinates to find the count of defects in the scatter diagram. please help me.
T1:
Load
Measure.MeasureKey as mk,
Measure.lensposx
as x,
Measure.lensposy
as y,
Measure.lensposx
+.05 as ux,
Measure.lensposx
-.05 as lx,
Measure.lensposy
+.05 as uy,
Measure.lensposy
-.05 asly
Resident
Measure
where
Measure.MeasureKey<50;
T2:
Load
Measure.MeasureKey as mk,
Measure.lensposx
as x,
Measure.lensposy
asy
Resident
Measure
where
Measure.MeasureKey<50;
T3:
IntervalMatch
(T2.x)
LOAD
T1.lx,T1.ux
Resident
T1;
Inner
Join(T3)
IntervalMatch
(T2.y)
LOAD
T1.ly,T1.uy
Resident
T1;
Inner
Join(T3)
LOAD
Count(T1.mk) asdefect
Resident
T1;
Please can you copy & paste the script again and make it readable? You can copy the script to notepad before posting here.
Cheers!
The scripts are:
T1:
Load Measure.MeasureKey as mk,
Measure.lensposx as x,
Measure.lensposy as y,
Measure.lensposx+.05 as ux,
Measure.lensposx-.05 as lx,
Measure.lensposy+.05 as uy,
Measure.lensposy-.05 as ly
Resident Measure
where Measure.MeasureKey<50;
T2:
Load Measure.MeasureKey as mk,
Measure.lensposx as x,
Measure.lensposy as y
Resident Measure
where Measure.MeasureKey<50;
T3:
IntervalMatch(T2.x)
LOAD T1.lx,T1.ux
Resident T1;
Inner Join (T3)
IntervalMatch(T2.y)
LOAD T1.ly,T1.uy
Resident T1;
Inner Join (T3)
LOAD Count(T1.mk) as defect
Resident T1;