I want to select records from an existing dataset based on this logic: going through each record from top to bottom, locate the record with value 0 such that all ensuing records always have value of 0, select that record and everything before that record. In the following dataset, I'm making such selection for each type value, and my desired results are records with id 4,5,8,9,10. How do I achieve this? Thanks. id type value 1 A 1 2 A 0 3 A 1 4 A 0 5 A 0 6 B 0 7 B 1 8 B 0 9 B 0 10 B 0
... View more