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);
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!