topic FGDB Joins in ETL in Data Management Questions https://community.esri.com/t5/data-management-questions/fgdb-joins-in-etl/m-p/630387#M35610 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to join the RoadCenterline feature class to the MasterStreetName table in the Local Government Model and export out a new shapefile to import into the Sheriff's Dispatch system. Everything is currently stored in a file geodatabase. I found the Joiner command but it seems to support everything except file geodatabases. Am I missing something obvious? How can I join this table to the feature class without having to export or create other files? Thanks.</SPAN></BODY></HTML> Tue, 04 Sep 2012 21:11:21 GMT TomNeer 2012-09-04T21:11:21Z FGDB Joins in ETL https://community.esri.com/t5/data-management-questions/fgdb-joins-in-etl/m-p/630387#M35610 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to join the RoadCenterline feature class to the MasterStreetName table in the Local Government Model and export out a new shapefile to import into the Sheriff's Dispatch system. Everything is currently stored in a file geodatabase. I found the Joiner command but it seems to support everything except file geodatabases. Am I missing something obvious? How can I join this table to the feature class without having to export or create other files? Thanks.</SPAN></BODY></HTML> Tue, 04 Sep 2012 21:11:21 GMT https://community.esri.com/t5/data-management-questions/fgdb-joins-in-etl/m-p/630387#M35610 TomNeer 2012-09-04T21:11:21Z Re: FGDB Joins in ETL https://community.esri.com/t5/data-management-questions/fgdb-joins-in-etl/m-p/630388#M35611 <HTML><HEAD></HEAD><BODY><SPAN>Have you taken a look at the FeatureMerger transformer? This allows you to merge features from different feature type based upon a common attribute. So in you case the RoadCenterline would be the requestor and the MasterStreetName wold be the supplier. All the feature that match will come out the Complete port as one joined feature.</SPAN><BR /><BR /><SPAN>-Sean</SPAN></BODY></HTML> Tue, 04 Sep 2012 22:08:42 GMT https://community.esri.com/t5/data-management-questions/fgdb-joins-in-etl/m-p/630388#M35611 SeanGrant 2012-09-04T22:08:42Z Re: FGDB Joins in ETL https://community.esri.com/t5/data-management-questions/fgdb-joins-in-etl/m-p/630389#M35612 <HTML><HEAD></HEAD><BODY><SPAN>Figured it out... Operator error.</SPAN></BODY></HTML> Thu, 06 Sep 2012 00:57:06 GMT https://community.esri.com/t5/data-management-questions/fgdb-joins-in-etl/m-p/630389#M35612 TomNeer 2012-09-06T00:57:06Z