Skipping a record when joining tables

LoganJackson — Tue, 22 Jul 2014 02:54:51 GMT

Here is the scenario: I am creating line segments between points to represent human migrations from place to place over time. Each point is attributed with City, State, Year, Lat, Long, etc, etc. What I am trying to do is join the point attributes to the newly created line segments. The trick is I need to join line segment 1 with point 2. Essentially line 1 needs the "Destination" attributes, not the "Origin" attributes. However, when I go to join the tables I can't join line 1 with point 2. It joins line 1 with point 1, thus giving the attributes from the origin point instead of the destination point. This might be confusing, so here's the example:

Points Table

FID ID Event City_Town State Country Year

0 1 Begin Seattle WA US 1986

1 2 Move Helena MT US 1988

2 3 Move ...

Line Segments Table

FID

Is there a way to join Line Segment FID 0 with Point FID 1? When I try to join the Lines Table FID with the Points Table ID a null record is added so that the tables line up at 1. Any way around this? Thanks.

Re: Skipping a record when joining tables

DanPatterson_Retired — Tue, 22 Jul 2014 03:43:32 GMT

you could simply add fields to the existing tables that reflect the pairing you want. There is an example towards the bottom of this help file link called autoincrement and you can adjust the start number accordingly between the two files.

topic Re: Skipping a record when joining tables in Data Management Questions

Skipping a record when joining tables

Re: Skipping a record when joining tables