Group a set of values with running no

[#1]

Hi,

My raw data is like below,

WF_ID	WF_NAME	WF_RUN_ID	ST	ET
10	A	1	10:00	10:02
20	B	2	10:02	10:05
30	C	3	10:06	10:10
10	A	4	10:00	10:02
20	B	5	10:02	10:05
30	C	8	10:06	10:10
10	A	11	10:00	10:02
20	B	14	10:02	10:05
30	C	17	10:06	10:10
10	A	20	10:00	10:02
20	B	21	10:02	10:05
30	C	22	10:06	10:10
10	A	23	10:00	10:02
20	B	24	10:02	10:05
30	C	25	10:06	10:10
10	A	26	10:00	10:02
20	B	27	10:02	10:05
30	C	28	10:06	10:10

I want to add a field which will like the below

WF_ID	WF_NAME	WF_RUN_ID	ST	ET		I want to assign like this
10	A	1	10:00	10:02		1
20	B	2	10:02	10:05		1
30	C	3	10:06	10:10		1
10	A	4	10:00	10:02		2
20	B	5	10:02	10:05		2
30	C	8	10:06	10:10		2
10	A	11	10:00	10:02		3
20	B	14	10:02	10:05		3
30	C	17	10:06	10:10		3
10	A	20	10:00	10:02		4
20	B	21	10:02	10:05		4
30	C	22	10:06	10:10		4
10	A	23	10:00	10:02		5
20	B	24	10:02	10:05		5
30	C	25	10:06	10:10		5
10	A	26	10:00	10:02		6
20	B	27	10:02	10:05		6
30	C	28	10:06	10:10		6

For this i need a script ..

Can any one give the script for this...

Thanks a lot...

Regards

Gangadharan M

[IAMDV]

Dear Gangadharan,

Please can you explain your question in detail? I can't seem to make any difference between the tables you pasted above... I might be confused, so please explain in detail with QV document if possible. So that we can create the script to test the output.

Cheers!

[#3]

Both the data you have look exactly the same, what do you want to achieve?

Please elaborate

[#4]

Hi,

Source data's are in Red color. Target data's are in blue color.

1. There are 3 sub jobs (AAA, BBB, CCC) running every 5mins once. We can say a job ran successfully one time, when all 3 sub jobs ran in the specified order (job_id 10, 20 & 30). And also job_run_id should be an incremental order.

2. I need to prepare a chart like

     a) How many time this job ran on the particular day?

     b) How many time this job get failed? etc.

Suggestion are welcome !!!

Thanks in advance.

Gangadharan M

[#5]

I hope you can understand my requirements now.