topic Re: Copy properties one field to another field with different field types in ArcMap Questions

Copy properties one field to another field with different field types

turguttosun — Sun, 30 Jan 2022 22:52:23 GMT

I have two different field with different properties as can be shown from photo.

I need to copy one field properties to another becaure there are more than 2000 rows.

When I try it gives error "The value is you entered is out of range or is not a whole number"

First field type is double second one is float. Thanks for answer.

DanPatterson — Sun, 30 Jan 2022 23:14:47 GMT

Did you just try a simple field calculation such that yukseklik calculated using Elevation as the value field to use

JayantaPoddar — Sun, 30 Jan 2022 23:43:43 GMT

As far as change of Field type of an existing field is concerned, you can't do it for a non-empty table.

You may delete the existing field (with NULL value), and create a new one with same name and the desired fieldtype.

turguttosun — Mon, 31 Jan 2022 06:18:04 GMT

I need to copy column 1 to column 2. I cant edit column 2 field type it should be long type.

DanPatterson — Mon, 31 Jan 2022 06:22:03 GMT

If column2 needs to be long, then you will lose the decimals when the copy is made.

And you would have to do

int(column1)

to do the rounding. If it was float, then the decimal values would copy over unless there was an overflow caused by the reduction in field type.

Did you try any of the suggestions?

turguttosun — Mon, 31 Jan 2022 06:40:33 GMT

thank you for answer. I havent use before field calculator. As I know in order to copy one to another, both fielld type should be same.

elevation(column 1) field type is double

yukseklik(column 2) field type is long

you wrote "int(column1)" be used in field calculator? thanks .

turguttosun — Mon, 31 Jan 2022 10:15:49 GMT

Thaks Dan, I tried just before it works!