3

I have a shape file with polygons and a xlsx sheet, and I need to join their tables using Join attributes by field value in the modeler.

At QGIS 2.18 it works perfectly, but in 3.4.7 the join doesn't work, but if I do a manual join at the properties of the shape, the join happens normally.

I´m looking for some help with this tool to use in the modeler.

Both colums have the same type and size. I already tried to reinstall QGIS and tried on different machines.

Here are some prints to shows the issue.

enter image description here The tables I want to join by the field FUNDO.

enter image description here Set up for the join.

enter image description here Nothing could be matched.

enter image description here

Set up for the manual join.

enter image description here Everything is joined.

1

In my case the auto-detected type of the joinig field in the xls-table did not match the field type of the shp (table: string; shp:integer). Calculated a new field in the shp in string-format with integer-to-string conversion of the data. Result: String-field (xls) <-> String-Field(shp)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.