Hi, I am not really sure how to explain this or what term to use so excuse me on the subject so i have this sample dataset below that i need to assign an incremental field (GROUP_ID), for every time it sees a 'B' status GROUP_ID ill have a +1 please see expected result for more info. **sample data ROW_NUM STATUS 1 A 2 A 3 B 4 A 5 A 6 A 7 B 8 A 9 A 10 B **expected result ROW_NUM STATUS GROUP_ID 1 A 1 2 A 1 3 B 1 4 A 2 5 A 2 6 A 2 7 B 2 8 A 3 9 A 3 10 B 3 cheers guys.
... View more