Hi Ramon, If I understood it right, that's what I did (because, as you said, the join is virtual). I just created a new shapefile which had the joined fields in the attributes table.
Then I opened the .dbf file in excel. Frederico -----Mensagem original----- De: [email protected] [mailto:[email protected]] Em nome de Ramon Andinach Enviada em: domingo, 26 de Junho de 2011 23:57 Para: qgis-user Assunto: Re: RES: [Qgis-user] exporting joined table to excel I think there might be a step missing. The new join tool doesn't create a new physical layer, but a virtual one. So to make it visible outside qgis, you need to save the layer you joined to first. I'd save it as some new name, and you can save it directly into CSV if you wish. -ramon. On 27/06/2011, at 05:25 , Frederico Mestre wrote: > It is a shapefile, but in the dbf was only possible to see the fields in the shapefile, not the joins. I just generated a new shape with the joined fields and only then opened the dbf in excel. > > Thanks for the suggestion! > > Frederico Mestre > > > -----Mensagem original----- > De: [email protected] > [mailto:[email protected]] Em nome de Alex Mandel > Enviada em: domingo, 26 de Junho de 2011 21:45 > Para: [email protected] > Assunto: Re: [Qgis-user] exporting joined table to excel > > On 06/26/2011 01:03 PM, Frederico Mestre wrote: >> Hello, >> >> How can export a table, which can be opened in excel (such as .csv), when I've got joined tables that I joined using the vector properties window join tool? >> >> Bye, >> >> Frederico Mestre >> >> > > If the layer is a shapefile then the dbf is openable in Excel already, no need to export. If it's in a database like Postgis or Spatialite then both of those have tools to export or dump csv. > > Alternately if you Right click on any vector layer loaded and do a Save As... Comma Separated Values is an output option. > > Enjoy, > Alex > _______________________________________________ > 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 _______________________________________________ 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
