IntervalMatch

[jagannalla]

Hi All,

Can any one explain me how the intervalmatch function works with beautiful example...I gone through reference manual pdf but there is no example. I understood little bit only.

[its_anandrjs · Accepted solution]

Hi,

I explain with an example there is two tables below

OrderLog:

load * inline

[

START,END   ,ORDER

01:00,03:00 ,A

03:01,05:00 ,B

05:01,07:00 ,C

07:01,09:00 ,D

09:01,11:00 ,E

];

EventLog:

load * inline

[

Time,Event,Comment

00:00,0,Start of shift 1

02:00,1,Line Stop

04:00,2,Line Restart 50%

06:00,3,Line Speed 100%

08:00,4,Start of shift 2

11:00,5,End of Production

];

Data:

Intervalmatch(Time) load

START,END

Resident OrderLog;

The two tables OrderLog and EventLog loaded noramally after that we need to create interval table like

Data:

Intervalmatch(Time) load

START,END

Resident OrderLog;

and then we get interval table with six fields a time column shows in which Time interval he comes in START and END time.

See the attached sample file.

Rgds

Anand

[jagannalla]

Thanks a lot for breify explination..but in which scenario we will go with interval match. I mean what output should we get while using interval match.

[its_anandrjs]

Hi,

If we want to set interval matchs for perticular type of groups like age suppose 10 age and we have this values so if i want to check in which intervals it is comes like is i say 5 to 15 whih is comes in this interval and i create a fields like

  5 to 15

16 to 25

26 to 35

some thing like that

Rgds

Anand

[jagannalla]

Thanks a lot..

can you explain how the following code works..

- Inspection table contains the field carrdatetime

- Shift table contains the fields Shift.ShiftKey, Shift.ShiftStart, Shift.ShiftEnd.

Temp:

IntervalMatch(carrdatetime)

LOAD Shift.ShiftStart,

    Shift.ShiftEnd

Resident Shift;

Inner Join (Temp)

LOAD Shift.ShiftKey, Shift.ShiftStart, Shift.ShiftEnd

Resident Shift;

Inner Join (Inspection)

LOAD Shift.ShiftKey, carrdatetime

Resident Temp;

DROP Table Temp;