Hi, I can't find a similar example already answered, so here goes:
The data looks like this -
_time, Terminal, MessageNumber
03:11, 10000023, 04
03:04, 80000011, 03
02:56, 10000023, 03
02:21, 50000055, 31
02:04, 10000023, 02
01:27, 60000054, 48
01:09, 10000023, 02
01:01, 70000089, 52
01:00, 10000023, 01
00:59, 80000090, 29
I need to find consecutive duplicates in the 'MessageNumber' field, for each 'Terminal'. Streamstats works for individual terminals, but I've not found a method for searching all.
Would really appreciate any help!
... View more