I'm attempting to parse data based on a count variable on each line for machine cycle times. In this situation, one data entry doesn't necessarily attribute to one cycle. Rather, a data entry can contain anywhere from about 1 to 4 cycles where the time between datestamps is averaged out over the number of cycles that entry contained. I would like each cycle to be its own line with a cycle time value so I can create an accurate time series plot to analyze trends. Would there be a way to loop each entry to create another under it until n-1 = gap?
-----EXAMPLE DATA-----
Datestamp CycleTime Gap
1/9/2017 2:00:13 PM 5.2 2
1/9/2017 2:00:29 PM 5.0 0
1/9/2017 2:00:34 PM 5.4 1
-----DESIRED OUTPUT-----
Datestamp CycleTime
1/9/2017 2:00:13 PM 5.2
1/9/2017 2:00:13 PM 5.2
1/9/2017 2:00:13 PM 5.2
1/9/2017 2:00:29 PM 5.0
1/9/2017 2:00:34 PM 5.4
1/9/2017 2:00:34 PM 5.4
Solved! Go to Solution.
@Jack_Nelson Attached is what @MarqueeCrew is suggesting. Let me know if you have any questions! Here is how the Generate Rows Tool would be setup:
The help file for the Generate Rows has several good examples.
@patrick_digan & @MarqueeCrew
Alteryx magic indeed!! Thanks for the help. I'm still somewhat of a novice and learning all the tools, surprised I didn't stumble upon this one!