Bug report #18765

Join layer without custom prefix shifts the fields along

Added by Dan Isaacs over 5 years ago. Updated over 4 years ago.

Category:Attribute table
Affected QGIS version:3.4.4 Regression?:No
Operating System:Windows 7 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:26652


If one layer is joined to another and no prefix is selected (by selecting custom field name prefix and then just blanking the box), the resulting join layer column are all one to the right of the one they should be.

For example layer 1 with field 'ID', joined to layer 2 with 'ID', 'Height' and Width', using the selected prefix '2' would have the height values in the height column, but when it's joined with no prefix (custom prefix, blank box), the values that are under 'Height' in layer 2 appear under 'Width' in layer 1.

QGIS Correct Field Names.JPG - Correct field names with a prefix (45.9 KB) Don Meltz, 2019-02-23 10:19 PM

QGIS Shifted Field Names.JPG - Shifted field names with an "empty" prefix (45.3 KB) Don Meltz, 2019-02-23 10:20 PM


#1 Updated by Jürgen Fischer over 4 years ago

  • Status changed from Open to Feedback

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

#2 Updated by Don Meltz over 4 years ago

Jürgen Fischer wrote:

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

I just ran into this problem today, using QGIS 3.4.
I believe it may have something to do with identical field names existing in each table.
In my case, the OBJECTID field heading gets removed from my joined table, by the values in the column remain, and the next field to the right becomes the field heading of the (former) OBJECTID column.

#3 Updated by Don Meltz over 4 years ago

See attached jpegs for an example.

#4 Updated by Giovanni Manghi over 4 years ago

  • Affected QGIS version changed from 2.18.18 to 3.4.4
  • Status changed from Feedback to Open

Also available in: Atom PDF