nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Define data type when using calculate field

Oliver_Burdekin

I'm using ArcGIS pro 2.7 and building a model that uses the "Calculate field" tool. I'd like the field to be a new field and it needs to be of the data type "double".

When inputting the parameters there is no option to select data type of the output field. The documentation says this is an optional parameter. However, where and how should this be entered into the dialog box?

Below is an example of what I have so far (calculating area in hectares). Currently this creates the output field as "text" data type.

Cheers,

Oliver

Encontre mais publicações marcadas com

Analysis

Geodatabase

Desktop

Accepted answers

All comments

LaVokas

This would help to change data type in model field calculator by adding field type as parameter of your Field Calculator tool.

DanielGamboa

Same issue with Python the Field Type seems to vanish as a selection. I switch to Arcade which has helped.

For your distinct issue, I used Add Field so that I can be specific of the Field Name, Field Alias, and Type, before I ran the next Calculate Field.

GrahamWood-HWC

I've got the same issue in Model Builder in Pro 2.8.2

I've found a workaround:

create the Calculate field in Pro
run it once and
drag it into your model from the GP history tab.
reconfigure to your model.

is this a bug?? Has it been submitted?

Oliver_Burdekin

This makes a lot of sense. Thanks Joshua.

bixb0012

So this appears to be more of a Model Builder issue than a Calculate Field issue.

In terms of Model Builder and an intermediate data source, I am guessing Model Builder isn't allowing the option because it has no idea what the schema will look like when the model is run. When you are pointing to an existing/original data set, Model Builder can lookup the schema of the data set and determine what fields do and don't exist, and hence give you the option to create a new field and set the data type. When working with intermediate data, it is derived and the schema won't be known until runtime so Model Builder isn't allowing that parameter to be set.

Oliver_Burdekin

Thanks David, the new dropdown is not appearing. The tool is being used in Modelbuilder and connected to an intermediate datasource. I've deleted all intermediate data and the yellow warning is to inform me that the field does not exist.

On further testing the dropdown doesn't appear when using the tool on intermediate data within Modelbuilder. It does appear if I use it on the original input feature class.
The workaround for intermediate data is to use the "add field" tool first within the model and then "calculate field"

Robert LeClair

I got it to work NOT using the CodeBlock - see attached image.

danretired

If memory serves this produces the field and allows you to do a calculation at once.

Calculate Fields (multiple) (Data Management)—ArcGIS Pro | Documentation

Even though it says "multiple" that includes one. The data type is determined from the calculation

DavidPike

The tool should then add a new dropdown of field type if its not in the table. I hate to ask, but does the field name already exist in the table? Also what is the error icon beside the field?

Robert LeClair

You're welcome Oliver - not sure about adding optional arguments in the codeblock as I have not done that workflow. I'll do some digging around and get back to you.

Oliver_Burdekin

Thanks Robert. I was looking at that as a workaround. Is there no way to add optional arguments through the codeblock?

Robert LeClair

Oliver - what I would do is create a new field and make it a DOUBLE. One the field exists, then you can run the Calculate Field geoprocessing tool.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.