How can I create a continuous query that only keeps points where a value changed?
Say I have this data
|time |IsRunning|Machine|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:18|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|FALSE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
|1/22/2019 21:19|TRUE|Z-1-8|
I want to continuously transform it to this
|time |IsRunning|Machine|
|1/22/2019 21:18|FALSE |Z-1-8|
|1/22/2019 21:19|TRUE |Z-1-8|
|1/22/2019 21:19|FALSE |Z-1-8|
|1/22/2019 21:19|TRUE |Z-1-8|