Join attributes when file names *beginnings* are the same

2533
1
07-30-2015 01:54 AM
ManuelFrias
New Contributor II

Hi,

In my geodatabase there are point and feature classes. I would like to join one field of the point feature class into the lines. Points and lines must start with the same name:

data_2014_scope_week_1__Project

data_2014_scope_week_1_Lines

data_2014_scope_week_2__Project

data_2014_scope_week_2_Lines

...

PointsLines.PNG

How to do this in model builder? Join Field would do the trick but how to do it in an iterative way?

0 Kudos
1 Reply
WesMiller
Regular Contributor III

I haven't tested this but when you use the add join field you field names change from field name to feature class name"."field name so i think you could use the add join then iterate over the table using the naming convention you may also need to test for fields that are named the same in both feature class the second occurrence may have the suffix "_1"  added to it.

0 Kudos