time range

[#1]

I have the rawdata for surveys done at each clinic

there is a column for time where its written in this format "hh.mm.Ss"

and another table for time of survey for each clinic to be done for example.  10:00pm - 9:00 am. so the common between 2 tables is Location

how can i check if the survey is done between that time or not??????

[er_mohit]

try this, as per your time format,like this

time(fieldname,hh:mm:ss) as time_survey

on both fields. then you get right format

[manideep78]

Hi,

See attached qvw and let me know if there are any issues

[#4]

this is good but doesnt help when we have time range for 23:00:00 to 04:00:00

[jagannalla · Accepted solution]

Hi,

How you are saying that  starttime 23:00 is yesterday's time. It can also be next day 23:00 time. We should have datetime in this case,then only you can achive your result.

For eg below one,KPHB result is expecting today's 23:00 time.

Clinic:

LOAD * INLINE [

    Clinic, Time, Location

    A, 09:00:00, Abids

    B, 08:34:45, Koti

    C, 10:43:56, Miyapur

    D, 12:12:12, Ameerpet

    E, 05:08:24, KPHB

];

Inner Join

LOAD * INLINE [

    Location, StartTime, EndTime

    Abids, 08:00, 10:00

    Koti, 09:00, 11:00

    Miyapur, 10:00, 12:00

    Ameerpet, 11:00, 12:00

    KPHB, 23:00, 06:00

];

ResiClinic:

LOAD Location, If(Time >= StartTime and Time <= EndTime,'T','F') as Flag Resident Clinic;

Hope it helps you

Cheers!!

Jagan