Table update

Ahmed, Shakir shahmed at sfwmd.gov
Tue Aug 28 08:57:51 EDT 2007


I am trying to use python script to update a table by incremental value
based on struc_No but having problem to get right result on the value
field for the 3rd and 4th same number of struc_no. 

I need to update the Value field only with the incremental value of 15
or so

Any help is highly appreciated.

Thanks
Shak



Input table or source table

ID	struc_id	Struc_No	Value	
1	ABC		1001		10	
2	EFJ		1005		15	
3	HIK		1003		10	
4	ILK		1005		10	
5	PIO		1001		8	
6	TIN		1001		12	
7	MNO		1001		11	
8	POW		1003		18	


Output Table				
				
ID	struc_id	Struc_No	Value		Added value
1	ABC		1001		25		15
2	EFJ		1005		30		15
3	HIK		1003		25		15
4	ILK		1005		40		30
5	PIO		1001		38		30
6	TIN		1001		57		45
7	MNO		1001		71		60
8	POW		1003		48		30





More information about the Python-list mailing list