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
  • 6 views
S
Forum|alt.badge.img

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.

1 reply

jovitaatsafe
Safer
Forum|alt.badge.img+11

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!

Reply


Helpful Members This Week

Community Stats

30,937
Posts
117,250
Replies
38,740
Members

Latest FME

Terms & ConditionsCookie settings

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
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.