XY to Line Output fields - value=0 for all rows

Discussion created by kwortman80 on Feb 15, 2012
Latest reply on Feb 15, 2012 by dlee-esristaff
Background: I joined two layers containing point data and am trying to use them as the input with the XY to Line tool.  I select start fields as table1.X, and table1.Y, then end fields as table2.X, table2.Y, then ID as table2.participant (the field on which the original tables are joined).  The output I get shows table1_x,table1_y,table2_participant,table2_x, and table2_y all with values of 0.  Shape_length has a (very small) > 0 value, but I suspect it is not accurate, since all other fields have a value of 0, and the value is so small.  The layers I'm using are projected using a state plan projection. 

1 - What would cause x,y, and id fields in the XY to Line tool output table to have a value of 0?
2 - What are the units of measurement for the Shape_Length field in the output table? 

Thank you for any insight!