bmhuettinger
Registered User.
- Local time
- Today, 01:52
- Joined
- Jul 28, 2017
- Messages
- 59
Good morning all,
I'll do my best to explain the issue...
We have manufacturing machine that exports a lot of data about how long it takes to complete each "pass" and the speed of the machine at any given interval when running coils of material. If I limit the time increment to only minutes and seconds, each pass could have 200-300 records before moving on to the next pass. Unfortunately, the one data point that isn't exported (or available) is a unique identifier for each coil. I need a query that looks for sequential patterns in the pass number, and after each coil has gone through all 5 passes (around 1500 records), it assigns the next group of data a "coil number" and starts the count all over again. In my test table, a 24-hour period, I have 9000 records that equates to approximately 8 unique coils.
I hope I articulated the situation properly. And I really hope there's a solution.
Thanks in advance.
I'll do my best to explain the issue...
We have manufacturing machine that exports a lot of data about how long it takes to complete each "pass" and the speed of the machine at any given interval when running coils of material. If I limit the time increment to only minutes and seconds, each pass could have 200-300 records before moving on to the next pass. Unfortunately, the one data point that isn't exported (or available) is a unique identifier for each coil. I need a query that looks for sequential patterns in the pass number, and after each coil has gone through all 5 passes (around 1500 records), it assigns the next group of data a "coil number" and starts the count all over again. In my test table, a 24-hour period, I have 9000 records that equates to approximately 8 unique coils.
I hope I articulated the situation properly. And I really hope there's a solution.
Thanks in advance.