[Qgis-user] joinning tables

[Siki Zoltan]

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 <siki at agt.bme.hu>
>
>> 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: siki at agt.bme.hu
>>>> To: qgis-user at lists.osgeo.org
>>>> CC: qgis-developer at lists.osgeo.org
>>>> 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
>>>> Qgis-user at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>>
>>>  _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> 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>
>