Data formatting help

[johnsasikumar]

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

[ITWhisperer]

Would it be more accurate to say that a cycle begins with SPWord = 0 and LineNumber = 1, and ends with SPWord = 8?

Also, can cycles overlap or will it always be

SPword=0 LineNumber=1
...
SPWord=8
SPWord=0 

[johnsasikumar]

@ITWhisperer : thank you

the Spword field for a cycle always starts with 0 and end with 8. 0 marks start of the cycle and 8 the end

there are no line numbers. That is something we added using accum