Dear Szilard,
thank your case study.
DBF file limits column names to 10 characters.
First I thought special Hungarian characters cause the problem, but
using only English ABC I got the same result.
Did you try to join my tables?
Did you get false result using textual columns?
Best Regards,
Zoltan
On Wed, 29 Jan 2014, Szabo Szilard wrote:
Dear Zoltan,
I had this kind of problem when I "hurt" the normal rules of field names
(i.e. using extra long field names bringing them directly from downloaded
TEIR tables); afterI correction them (shortening but I am not sure the
threshold), everything was fine. But You have correct and short field names
... my response is just a case study.
Best regards,
Szilard
2014-01-29 Siki Zoltan <[email protected]>
Dear James,
thanks for your answer.
My data are available here:
http://www.agt.bme.hu/gis/qgis/ods.zip
You can find in the zip a shapefile (megye_utf-8), and some spreadsheet
files (ksh.ods, ksh.xlsx, ksh.csv) having the same data. All use utf-8 code
page.
Open megye_utf-8 and ksh.ods and make a join using "megye" and "Nev"
columns. I get NULL data in all joined column.
If ods or xlsx is not supported on your platform, you can use ksh.csv.
If you join the two tables using "kod" (integer value) column, the result
is OK.
I tested it in 2.1, 1,7 and 1.8 on Linux and in 2.1 on Windows.
Best Regards,
Zoltan
On Wed, 29 Jan 2014, James Wood wrote:
Zoltan,I don't know if someone has responded to you about this; I didn't
see any list posts. I am not seeing the same issue with textual joins in my
QGIS 2.0.1 install. If you want to provide me with your shapefile and your
join files, I'll be happy to test here.
Best Regards,James
Date: Sat, 25 Jan 2014 20:43:59 +0100
From: [email protected]
To: [email protected]
CC: [email protected]
Subject: [Qgis-user] joinning tables
Dear List,
I got into trouble joining tables in QGIS.
When I try to join shape to a csv, ods or xlsx file using columns with
textual data, it doesn't work. I get only NULL values in the joint
columns.
Using integer values the join works.
Is it a feature or an error?
Regards,
Zoltan
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
--
Dr. Szilard SZABO
associate professor, head of department
Department of Physical Geography and Geoinformation Systems
University of Debrecen
http://www.mendeley.com/profiles/szilard-szabo/
Publications <https://vm.mtmt.hu/search/slist.php?lang=0&AuthorID=10000172>
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
