field-calculatorindexingvbscript
When using the field calculator, how do I get data from the previous row in VBScript? In Python I'd do something like this:
for index, row in enumerate(rows,start=1):
row[index-1] += 5
I'm using ArcGIS 9.3.1.
Let's assume I have a column [Distance] and all it's rows are 0. How do I increment every row with 5 starting at row 1. So the first row remains 0, second row'll be 5, third 10 and so on.
Try something like this:
dim f2
if [field1] = "foo" then
f2 = "bar"
end if
Screen shot of this being used in the field calculator.
The table processing you describe is accomplished as a straightforward summary.
In the example, use [Style] as the key in the summary. Let's flesh out the example a little. Suppose the table contains
-----------[STYLE]----------[STYLE_CODE]
Feature 1 [4WD]----------------[]
Feature 2 [DIVIDED]------------[]
Feature 3 [HIGH CLEAR]---------[]
Feature 4 [4WD]----------------[]
Feature 5 [4WD]----------------[]
Feature 6 [HIGH CLEAR]---------[]
Feature 7 [4WD]----------------[]
where "[]" denotes anything. Then the summary would be
[OID]--[STYLE]----[COUNT]
1--[4WD]------------4
2--[DIVIDED]--------1
3--[HIGH CLEAR]-----2
There it is: your lookup table. Just copy the unique identifier [OID] into a new [Style_Code] field. You can join this table to any other table that contains a match to [Style], thereby accessing the corresponding style code in the foreign key [Style_Code].
Best Answer
This script is from the Easy Calculate 5.0 Scripts by Ianko Tchoukanski
This section goes in the code block. Set the
lIntervalandlStartvalues as necessary. In this case,lInterval = 5andlStart = 0.Place this in the
[Field Name] =area: