I have seven point shapefiles at the same geographic location with three common fields (
"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