Skip to main content
  • EN

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.

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


Community Stats

30,176
Posts
114,542
Replies
37,835
Members
Terms & ConditionsCookie 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.