Merge Vector Layers fails in QGIS

Question

I'm trying to merge two vector layer as part of a graphic model but get an error:

OBJECTID field in layer layer1 has different data type than in other layers (Integer64 instead of Real) Execution failed after 0.06 seconds

And both layers have a field called OBJECTID with different data types. I don't care about the attributes I just need the geometries. Isn't there a way of telling merge to ignore the attributes?

I would rather not have to drop/rename all fields prior to merge (I have a lot of layers, not only these two with many fields to drop). Maybe there is a QGIS equivalent of ArcGIS MakeFeatureLayer to disable fields prior to merging.

Answer 1

Another solution that may be used particularly in the Processing Modeler.

Let's assume we have two layers "layer_1" and "layer_2" with its corresponding attribute tables accordingly, see image below.

With the following model, it is possible to merge two vector layers with no attributes only their geometries.

The output with its Attribute table will look as following

---

Note:

1. On the last image, attributes were added by default

2. For both SQL queries use these settings

   

Answer 2

I can suggest some PyQGIS but not sure if it corresponds to your requirements

layer_1 = QgsProject.instance().mapLayersByName('unit_1')[0]
layer_1_new = processing.run('qgis:deletecolumn',
    {'INPUT': layer_1,
    'COLUMN': ['id', 'length'], #here you will need to specify all the columns that have to be erased for the first layer
    'OUTPUT': "memory:"}
)["OUTPUT"]

layer_2 = QgsProject.instance().mapLayersByName('unit_2')[0]
layer_2_new = processing.run('qgis:deletecolumn',
    {'INPUT': layer_2,
    'COLUMN': ['id'], #here you will need to specify all the columns that have to be erased for the second layer
    'OUTPUT': "memory:"}
)["OUTPUT"]

layer_merged = processing.run('qgis:mergevectorlayers',
    {'CRS': 'EPSG:***', #use a proper EPSG
    'LAYERS': [layer_2_new, layer_1_new],
    'OUTPUT': 'memory:'}
)['OUTPUT']

QgsProject.instance().addMapLayer(layer_merged)