Hello all, Below is the sample data of one cycle. Similarly there are several cycles The data below is from sensor values. Each cycle starts with Spword:0 and ends with SPword 8. How do i group the...
See more...
Hello all, Below is the sample data of one cycle. Similarly there are several cycles The data below is from sensor values. Each cycle starts with Spword:0 and ends with SPword 8. How do i group these as cycle1,2,3 based on the SPword field. The timedifference for all cycles is not same and also when i use transaction command am not able to name it as cycle 1,2. Please could you help "_time",FrontFormedHeight,Pot,LVDT,LoadCell,SPWord,LineNumber,cycl "2020-09-29T14:01:24.000+0000","2.703","67.64","0.198",0,0,1,CycleStart "2020-09-29T14:01:26.000+0000","2.703","67.63","0.198",0,0,2,CycleStart "2020-09-29T14:01:29.000+0000","2.703","67.64","0.198",0,0,3,CycleStart "2020-09-29T14:01:31.000+0000","2.703","67.63","0.195",0,0,4,CycleStart "2020-09-29T14:01:34.000+0000","2.703","67.64","0.198",0,0,5,CycleStart "2020-09-29T14:01:36.000+0000",0,"67.64","0.198",0,1,6, "2020-09-29T14:01:38.000+0000",0,"51.66","0.198",0,,7, "2020-09-29T14:01:39.000+0000",0,"24.61","1.565",0,2,8, "2020-09-29T14:01:41.000+0000",0,"24.59","1.59",0,2,9, "2020-09-29T14:01:43.000+0000",0,"18.3","7.551","1160.9241004669334",,10, "2020-09-29T14:01:44.000+0000","2.52","67.43","0.195",0,4,11, "2020-09-29T14:01:46.000+0000","2.52","15.53","1.413",0,5,12, "2020-09-29T14:01:48.000+0000","2.52","12.1","4.471","472.4265266884365",,13, "2020-09-29T14:01:51.000+0000","2.52","67.53","0.195",0,7,14, "2020-09-29T14:01:53.000+0000","2.52","67.59","0.195",0,,15, "2020-09-29T14:01:56.000+0000","2.52","67.64","0.198",0,8,16,cycleEnd