Skip to main content
Question

Join multiple unit tables to one main geometry table based on one common_id field.

  • January 8, 2020
  • 1 reply
  • 9 views
sudhakary
Contributor
Forum|alt.badge.img+1

I want to join multiple unit tables to one main geometry table based on one common_id field.

 

The scenario as follows

 

Main_Table1 ===> Unit_Table1

Main_Table1 ===> Unit_Table2

Main_Table1 ===> Unit_Table3

 

Main_Table2 ===> Unit_Table1

Main_Table2 ===> Unit_Table3

Main_Table2 ===> Unit_Table4

Main_Table2 ===> Unit_Table5

 

Main_Table3 ===> Unit_Table1

Main_Table3 ===> Unit_Table5

Main_Table3 ===> Unit_Table6

Main_Table3 ===> Unit_Table5

 

The main table is having the geometry and the unit tables are having the attributes. One unit table contains attributes of multiple geometry tables as shown above.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

jovitaatsafe
Safer
Forum|alt.badge.img+11
  • jovitaatsafeSafer
  • Safer
  • 635 replies
  • January 9, 2020

Hi @sy0520,

If I'm understanding correctly that you're looking to merge additional attributes to a table schema based on a common ID, this tutorial on the FeatureJoiner might be a helpful place to get started on your workflow. Hope that helps a bit!

Community Stats

32,079
Posts
121,805
Replies
39,710
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.