I am struggling with copying the data from one attribute data table to another. I have a few columns in my data attribute table, which I want to update. I can do it one by one, but its a long process, as I have about 150 records.
I decided, than it will be quicker if I do it in Excel instead, then import them into QGIS and replace the data in existing attribute data table.
I decided to do it in the following steps: 1. Export attribute data table to .csv 2. Make autofill in Excel 3. Import the new attribute data table to the QGIS again As an import I used option: Layer-Add Layer - Add delimited text layer. After loading layer I have it own attribute layer, which I would like to copy to the attribute layer of my existing layer as per image below:
1 - my comma delimited layer imported 2 - my existing shapefile layer, where I would like to replace the attribute layer from this 1st one.
I found some solutions here:
Joining data from Excel to attribute table in QGIS without creating duplicates?
and here:
How to copy information from Excel into QGIS Attribute-Table?
but they don't really solve my issue. I wish I could use the table joining option, but it looks like the differ columns are to be added instead to replace all with the same names.
Can anyone help me to autofill the attribute data table or fetch it from Excel?
join attributes by field
after importing the excel file? Have you tried exporting the data including WKT-geometries, which later can be loaded again omitting the need for any joins?