Intermatch

[abdulrahman]

Hi,

I am facing a problem with interval match. I need to match values of date and time from one table to date and time periods in another table. Intervalmatch is working fine except at two values of time i.e 2:15 and 3:45. Its showing null values where it is supposed to show matching time interval. 
Second Problem is synthetic key, since im matching two columns from a single table to the other, it is creating a synthetic key.

My script is

Organization:
LOAD
Organization,
Site,
"Data Point",
KWH,
Power,
C1,
C2,
C3,
V1,
V2,
V3,
Time("Time") as TIME,
Date("Date") as DATE
FROM [lib://Data/Dummy Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Peak:
LOAD
Date("From") as From,
Date("TO") as To,
Time(FromTime) as FromTime,
Time(ToTime) as ToTime,
Status,
Tarrif
FROM [lib://Data/Dummy Data.xlsx]
(ooxml, embedded labels, table is Sheet2);

Inner Join
IntervalMatch(TIME)
Load
FromTime,
ToTime
Resident Peak;

Inner Join
IntervalMatch(DATE, TIME)
Load
From,
To,
TIME
Resident Peak;

Thank You

[lironbaram]

hi 

have a look at the attachment 

i changed the interval match to work with timestamp ,  

i think this will solve your problems 

[abdulrahman]

Thanks man!
It stops showing null values but it is not working as it should be. In data source 2:15 and 2:16 appears only once so they should only appear once against the interval they fall in, instead it is appearing against both the intervals.
Previously time was only appearing against its respective period but null value was appearing in 2:15 period, now that is solved but it is showing the time against the period it falls in as well as the period it dont fall in!