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:
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?