I have seven point shapefiles at the same geographic location with three common fields ("ID"
, "name2"
, "name3"
) and a fourth field, ("uni_value"
) that is unique to each shapefile.
All seven shapefiles have been produced by a QGIS Graphical Modeler workflow and would like to combine all layers into a single table for export into a PostgreSQL database.
Example tables below:
Point Layer 1
ID | name2 | name3 | unique_value1
Point Layer 2
ID | name2 | name3 | unique_value2
Point Layer 3
ID | name2 | name3 | unique_value3
.
.
.
Point Layer 7
ID | name2 | name3 | uni_value7
Final Merged table:
ID | name2 | name3 | uni_value1 | uni_value2 | ... | uni_value7