topic Re: How to select specified values for attribute tables? in Data Management Questions

How to select specified values for attribute tables?

CarstAway — Thu, 18 Apr 2019 13:09:11 GMT

Hello,

first, sry for my english!

I have to copy one attribute column of an attribute table (>200k values) in the same attribute table. This attribute column has around 40 different values, but for the copy I just need around 5 defined values. All other values have to been deleted. What is the fastest way to do this for big data like this?

Second problem: I have to rename (shorten) this 5 values in the new column ot the attribte table, what is the best way to do this?

Best wishes,

Carstaway

Re: How to select specified values for attribute tables?

ColeAndrews — Thu, 18 Apr 2019 19:41:06 GMT

Do you know what a definition query is? Add a definition query to the layer so that only the 5 values are present in the table. Then copy the fields.

Re: How to select specified values for attribute tables?

CarstAway — Tue, 23 Apr 2019 09:45:43 GMT

Hello,

thank you very much!

This is an good idea for the selection. But this leads to another problem:

I have to rename the values in the new column of the attribute table, like "tree" to "plant", is there any function for this? Or do I have to rename each value by hand?