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
