Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have the folllowing set of data
OPERATOR DATE
Andrew 01-DEC-17 10:40:17
Andrew 01-DEC-17 10:41:36
Andrew 01-DEC-17 10:47:21
Andrew 01-DEC-17 10:48:02
Nicole 01-DEC-17 10:51:05
Nicole 01-DEC-17 10:51:10
Andrew 02-DEC-17 10:51:15
Andrew 02-DEC-17 10:54:10
Sophie 02-DEC-17 10:55:40
Sophie 02-DEC-17 10:57:21
I would like to add a column with a progressive number based on the two fields above; the result should be like this:
OPERATOR DATE PROGRESSIVE
Andrew 01-DEC-17 10:40:17 1
Andrew 01-DEC-17 10:41:36 2
Andrew 01-DEC-17 10:47:21 3
Andrew 01-DEC-17 10:48:02 4
Nicole 01-DEC-17 10:51:05 1
Nicole 01-DEC-17 10:51:10 2
Andrew 02-DEC-17 10:51:15 1
Andrew 02-DEC-17 10:54:10 2
Sophie 02-DEC-17 10:55:40 1
Sophie 02-DEC-17 10:57:21 2
Thank you in advance
In your LT calculation, skip all rows with PROGRESSIVE = 1. Those rows mean that either the OPERATOR or the JUSTTHEDATE value has changed.
BTW we prefer that you start a new discussion for every new question.