Generating a line based on values in two attribute fields

Discussion created by Asenaith on Apr 20, 2012
Latest reply on Apr 20, 2012 by dkwiens
Hi, I am trying to figure out how to generate a line so that it begins in the location of column 1 and ends at the location of column 2.  The data I am trying to record is biomass transit between counties based on their county fips code, which I have represented in a separate centroid point file.  So I have a centroid point file with fips codes and x,y coordinates for each county centroid point, and I have a separate line file with the "From" county fips in one column, the "To" county fips in the second and the total biomass in the third column.  I tried to do a table join based on fips and county 1 so I would have the x,y coordinates so that I could do a feature to line, but that did not work and now I'm not sure what to do.  I have been drawing them by hand, but I have hundreds of entries. Any help would be appreciated. Thanks.