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

Reply via email to