AnsweredAssumed Answered

Join tables in model builder

Question asked by mfrias on Jul 29, 2015
Latest reply on Jul 30, 2015 by mfrias

Hi,

 

I am building a model to fetch tables with point data from a folder and make lines. Each file contains one week  of AIS (Automatic Identification System) data, i.e. shipping data.

 

The attribute table of the points contain the following fields

TablePoints.PNG

 

 

For making the lines I am using a publicly available script called TrackBuilder. The attribute table of the lines look like this:

 

TrackBuilderResultTable.PNG

 

The problem is that the field "shipType" is missing. I would like to modify the script (see attachment) to get that field in the lines attribute table.

 

I thought I could add a join to the model but I didn't succeed.

 

ModelPointsToLines.PNG

 

 

As you see above, the TrackBuilder script doesn't output a feature dataset that I can use to join it with the point table and get the "shipType".

 

TrackBuilderMenu.PNG

 

Any ideas on how to modify the script or alternative solutions are welcome!

Outcomes