AnsweredAssumed Answered

Field Calc using multiple fields and multiple rows

Question asked by kbrinkman on Sep 10, 2015
Latest reply on Sep 10, 2015 by kbrinkman

Hi Everyone!

 

I'm trying to calculate the length between two points using their Northing, Easting and Elevation values. Currently I have been exporting my shape file and calculating these valves in excel but would like to find a way to do this in ESRI so it is part of the shapefile. Is there a way to use the field calculator to create an expression that uses multiple fields and multiple rows? I'm currently using ArcGIS 10.2.2

 

For example:

 

ABCD
1NorthingEastingElevationCalc FieldResult
25248152.6585984.46.84500.00
35248152.5585984.316.805=SQRT((A3-A2)^2+(B3-B2)^2+(C3-C2)^2)0.16
45248152.4585984.236.882=SQRT((A4-A3)^2+(B4-B3)^2+(C4-C3)^2)0.13
55248152.3585984.166.805=SQRT((A5-A4)^2+(B5-B4)^2+(C5-C4)^2)0.13

 

I'm familiar with VBA but not so much python.

 

Thanks in advance!

Outcomes