Hello Community,
R returns integer(0) when I try to use the which function as follows:
> which(diff(Query1[1:1e3,"D83"]) == -1)
integer(0)
When I pull the data to R, the command works just fine.
> query2 <- ore.pull(Query1[1:1e3,"D83"])
> which(diff(query2) == -1)
2016-04-01 00:12:37 ....
1 ....
Query1 is generated as follows:
> ore.sync(query = c("Query1" = "SELECT TIME, C0, C1, C5 C6, C16, C17, C18, C19, D78, D82, D83 from ARP ORDER BY TIME"),
user.keys = T)
D83 is a 0/1 variable and I am trying to capture the time of change from 0 to 1.
Thank you,
Akthem