Forum Discussion

fishboneox's avatar
fishboneox
Frequent Visitor
8 years ago

Create unique ID to group

Hi, I'm currently struggling with a perhaps easy problem but still i do. Analysing sensor data of a moving object I am measuring the start and end event of one move. Therefore my table looking like...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi fishboneox

 

Are you referring to the missing ranks

 

For example 163 should be 167...right??

 

Could you share your file?

fishboneox's avatar
fishboneox
Frequent Visitor
8 years ago

I've found the problem in this case. The value was rounded. So the method with the ranking won't work in this case:

 

Start_MovementEnd_MovementD_ID
26.03.2018 07:04:21 152
26.03.2018 07:04:22 153
26.03.2018 07:04:23 154
26.03.2018 07:04:24 155
 26.03.2018 07:04:25156
26.03.2018 07:04:32 163
26.03.2018 07:04:33 164
26.03.2018 07:04:34 165
26.03.2018 07:04:35 166
26.03.2018 07:04:36 167
26.03.2018 07:04:37 168
 26.03.2018 07:04:38169
26.03.2018 07:04:46 177
 26.03.2018 07:04:47178
26.03.2018 07:04:54 185
26.03.2018 07:04:55 186
26.03.2018 07:04:56 187

 

But thanks for the effort. Really appreciate it