Skip to main content
Solved

Hi! I want to retrieve related features from a relationship class and export them to a new feature class

  • November 28, 2016
  • 1 reply
  • 20 views

Hi! I have a fc "Points of Interest" and extra information about my points stored in the "Details_table":

I would like to be able to export my"Points of Interest" fc retrieving also the related extra information from the "Details_table", like TELEPHONE or WEBSITE

I found a solution that works, but I would like to know if you know a simple way of doing this. My solution:

1. I create a 1:1 relationship class with attributes associated to the relationship (ArcCatalog)

2. I populate the relationship class (Data Interoperability)

3. I export the table associated to the relationship class (ArcCatalog)

4. I turn back in Data Interoperability and use a Joiner to bring the GUID_POI field on my Details_table (from the previously exported table), and then a Feature Merger to bring on Point of Interest the related attributes from the Details Table

In the end I have a new fc with Points of Interest and also the "TELEPHONE" field that was in the Details_table

I would like to skip these two steps:

1. creating the associated table for the relationship class (for 1:1 and 1:M the relationship does not require a table to be create din the database)

2. exporting the associated table

so just directly accessing the related info from the Details table, and export it

any idea?

Best answer by roxananazarie

Hey I found the solution: so there's no need to create an associated table for the relationship class and export it.

So after I populate the relationship class, I simply use a Joiner on my fc to bring the extra info stored in the Details_table, based on the Primary and Foreign Key; I can also specify the fields that I want to retrieve

View original
Did this help you find an answer to your question?

1 reply

  • Author
  • Best Answer
  • November 29, 2016

Hey I found the solution: so there's no need to create an associated table for the relationship class and export it.

So after I populate the relationship class, I simply use a Joiner on my fc to bring the extra info stored in the Details_table, based on the Primary and Foreign Key; I can also specify the fields that I want to retrieve


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings