Question

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

  • 8 January 2020
  • 1 reply
  • 1 view
S

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
Rank
Userlevel 1
Badge +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


Community Stats

28,666
Posts
109,343
Replies
36,535
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.