ID Data Output Output should be 222 AB Cycle1 Cycle1 222 AB Cycle2 Cycle2 222 AB Cycle3 Cycle3 222 e Cycle4 Cycle3 222 ffg Cycle4 Cycle3 222 aa Cycle4 Cycle3 222 ff Cycle4 Cycle3 222 df Cycle4 Cycle3
but in other scenario it coming correctly ID Data Output 111 a Cycle1 111 b Cycle1 111 c Cycle1 111 d Cycle1 111 AB Cycle1 111 j Cycle2 111 k Cycle2 111 AB Cycle2 111 kl Cycle3 111 hg Cycle3 111 hgg Cycle3 111 AB Cycle3
Why would it not increment to cycle4? Seems like the logic is always incrementing by 1 if there is AB on the previous row. This look like a special scenario and providing a fix for this might break other places...
There might be, but like I said it might break other places... what is so unique about this example which makes you into increment by 1 after AB on the previous row? what if the data was like this?
222, AB
222, AB
222, AB
222, AB
222, e
or this
222, AB
222, AB
222, AB
222, AB
222, AB
There are 1000 possibilities that could happen, how do we find the anomalies?
