If I export my joined table to CSV I get the numeric id value instead of the value relation name from the joined table.

Can I export my table with the value relation value?

  • Haven't tested this but have you tried selecting all features in the Attribute Table , clicking the Copy selected rows to clipboard and then pasting it into a csv document? – Joseph Aug 18 '15 at 11:41
  • Try installing the mmqgis plugin, you get more options for exporting to csv – julsbreakdown Aug 18 '15 at 11:51
  • Joseph, that is what I tried first but it did not work neither. juls, forgot about mmqgis, will try it. – geogrow Aug 18 '15 at 14:45
  • I solved it in the end by doing a join in my postgis db I use instead . But I will give juls suggestion a try too for future reference – geogrow Aug 18 '15 at 14:47
  • I tried the mmqgis tool just now as well. The export did not keep the value relation in the csv file neither. – geogrow Aug 19 '15 at 10:18

I found a solution. To date it does not seem possible to export the attribute table to a csv and keep the value relation at the same time.

There is however a way of accomplish it by using a your SQL client. I just made a join between the Child and the Parent table to display the value instead of the numeric id number.

Note: If you are working with *.shp you can always import them into spatial lite to do the join in SQL language.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.