|
|
 top
|
  Subject: csv counting dependencies
Author: Jon Gallegos
Date: 19 Jan 2011 04:16 PM
|
I am trying to create a sequence number based on two fields. the code I have right now is not working
this code
count (distinct-values (preceding::PROCESS_NO))+1
gives me the sequence "1, 2, 3, 4, 5, 6, 7"
However, i want the sequence "1, 2, 3, 1, 2, 3, 4"
Here is an example of the data
TEAM_NO PROCESS_NO
A-1 21140
A-1 21140
A-1 21141
A-1 21141
A-1 21141
A-1 21141
A-1 21326
A-1 21326
A-1 21326
A-2 21990
A-2 21990
A-1 21145
A-1 21145
A-2 21145
A-2 21145
A-2 21148
A-2 21148
A-2 21148
A-2 21148
A-2 21342
A-2 21342
A-2 21342
How can i do this?
|
|
|
|
