[GIS] Simple Field Calculation With No Results in ArcGIS Pro

arcgis-proconcatenationfield-calculatorpython-parser

I have a grid in ArcGIS Pro that I've named the X and Y axis (in separate columns) and am now trying to do a field calculation on the total grid name (I've tried using both single and double quotes. I've tried using just a space, to test if maybe I needed an escape character):

!XAxis! + '-' + !YAxis!

!XAxis! + "-" + !YAxis!

I don't receive an error, but I don't receive any results in my table (and yes, I have refreshed multiple times and multiple minutes after running the script, knowing that sometimes there seems to be a lag in Pro)

I've used the verification at the bottom of the screen to test my syntax and it comes out clean. No errors on run, in fact, it states that it is running successfully:

I've double checked my work against Esri articles and other things I've found online… https://support.esri.com/en/technical-article/000018207

I know that there are still a few odd bugs with Pro, but I'm hoping to find a work around (other than opening up Desktop and solving it there).

I have used a Field Calculation earlier in this exact same table to swap the X and Y axis values, when I saw that the labels did not match reality. So it's not that I don't have permissions to the table or anything like that.

All three fields I am working with (XAxis, YAxis and GridLocation) are all text fields with X & Y having field lengths of 5 (even though none are above 2 characters) and GridLocation having a field length of 15 (even though the calculation would never put the length above 11, even if both the other fields were maxed out).

Best Answer

Deleting the field and recreating it worked for me. Never was able to get to the root of the problem, but a lot of things to look into if you run into a similar issue (see below).

Other things to attempt if you run into the same issue:

*Look to see if you have the same alias assigned to another field

*Make sure that you do not have records selected and the calculation is occurring on those rows

*Make sure the field is not read-only

*Check your permissions for the table/feature/etc

*Double check your syntax

*Fields are of the correct type and you are not trying to add an integer to a string, etc. Also, field lengths are able to handle the concatenated value.

*Restart Pro to see if you can reset whatever may be causing this

*Delete the field and re-create if all else fails

Related Solutions

[GIS] Find/Replace Double Quotes using Python Parser of ArcGIS Field Calculator

I have found that in 10.0 Field Calculator is quite weird.

But I've managed to get it work. The main idea is to enclose field name with single quotes.

Example. let suppose we have fields text1 and text2. Rather than Calculating field text2 with expression !text1!, which probably will fail, try this one: '!text1'. As you see I am using single quotes here.

So, back to your task. It will be more clear to use Pre-Logic Script Code:

def calc(value):
    return value.replace('"', '')

Expression will be:

calc('!text1!')

I hope it will work for you.

I have not experimented further but I think that such weird behavior happens because field calculation is translated into the call to ArcToolbox tool CalculateField_management and expression is provided as a parameter to it (probably additionally enclosed with single or double quotes).

UPDATE:

My previous solution will fail in case if there are single quotes in the values of field text1.

Now I have managed to get it work both in case when there are chars ' and " (single and double quotes) inside any value in attribute text1.

Here is expression, which will return original string, supporting both types of quotes:

'''!text1!'''[1:-1]

For your task it can be extended to (without Pre-Logic Script Code):

'''!text1!'''[1:-1].replace('"', '')

[GIS] Writing If-Then statement in ArcGIS Pro field calculator using Python

If I understand your question to simply be how to migrate the VB code into Python, see below. It's all basically the same, just minor differences in the syntax. The biggest syntax difference is the!fieldname!. This is how, using Python in the Calc Field tool you pass fields within the dataset into the code block.

Using Calc Field, you'll want to set Panel_Status == ifelse(!Eval_Status!, !Last_Panel!)

Code block:

def ifelse(evalstat, lastpanel):
    if evalstat == "Dormant":
        return "Dormant"
    elif evalstat == "Reject":
        return "Reject"
    else:
        return lastpanel

Results:

Best Answer

Related Solutions

[GIS] Find/Replace Double Quotes using Python Parser of ArcGIS Field Calculator

[GIS] Writing If-Then statement in ArcGIS Pro field calculator using Python

Related Question