1

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?

5
  • 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, 2015 at 11:41
  • Try installing the mmqgis plugin, you get more options for exporting to csv Aug 18, 2015 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, 2015 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, 2015 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, 2015 at 10:18

1 Answer 1

1

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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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