I have a scenario where when a device checks in, it sends multiple records of it's inventory with the same time stamp. The check-in time is random but grouped by timestamp. With a given dataset: 5am fruit=apple 5am fruit=orange 5am fruit=banana 7am fruit=apple 7am fruit=orange 12pm fruit=orange 12pm fruit=banana What I would like to see if there is a way to determine when one record exists but another record does not exist for a given time. For instance, note when apple is present but banana is not present like the 7am time.
... View more