topic Re: Calculate fields in ArcGIS Pro Questions

Calculate fields

jaykapalczynski — Thu, 29 Mar 2018 17:59:52 GMT

I am trying to concatenate a couple XY values

I have the X and Y fields (Double data type)

I created a Test field (string)

CONCAT(X, Y)

Then simply tried to calculate a simple test field

NAME - this is a field name

I get this error:

ERROR002536 Table Jurisdictions does not support or is in a state to support SQL Expressions

Any thoughts? Can do this in ArcMap in 2 seconds...ArcPro....ugggggg

Re: Calculate fields

JoeBorgione — Thu, 29 Mar 2018 21:01:00 GMT

Don't have an answer for you; how do you use CONCAT(X,Y) in ArcMap? I get the same error as you in ArcGIS Pro using the SQL parser choice, but if fails in ArcMap for me. I've never used CONCAT(X,Y) before and had to google it just to find out what it is.

I got this simple Python def() to work in Pro:

Re: Calculate fields

DanPatterson_Retired — Sat, 11 Dec 2021 14:59:27 GMT

python parser

X and Y , two fields

x = 10

y = 20

"{} {}".format(x, y)
'10 20'‍‍‍‍‍‍‍‍‍‍‍‍

you would therefore use !YourField! for each of the x and y values.

String concatenation in python, or check out arcade. but vb stuff is the new cobol

Re: Calculate fields

jaykapalczynski — Fri, 30 Mar 2018 12:38:44 GMT

That's guys....both do the trick....have to pick one for the answer....I like Dan's simpler approach but both answers are greatly appreciated....Still confused why simply SQL statements are not working in the SQL Expression Type

Somethin such as the below is failing

FieldName =

'TestingValue'

FieldName=

"TestingValue"

Re: Calculate fields

KoryKramer — Fri, 30 Mar 2018 13:07:03 GMT

You said that you get

ERROR002536 Table Jurisdictions does not support or is in a state to support SQL Expressions

That's the error in Pro? Can you send a screenshot? What database are you working with (file, Oracle, SQL server, etc.?) and version?

Re: Calculate fields

jaykapalczynski — Fri, 30 Mar 2018 17:18:19 GMT

This is ArcGIS Pro 2.1.2

I am simply hitting a shapefile - I havent tried on a GDB or SDE FC

Re: Calculate fields

DanPatterson_Retired — Fri, 30 Mar 2018 17:56:25 GMT

python3

Re: Calculate fields

jaykapalczynski — Fri, 30 Mar 2018 18:17:22 GMT

my example was the most simplistic I could think of...why does it fail with SQL Expression, which is the main question in this thread...

I was able to get it working in Python3

Re: Calculate fields

DanPatterson_Retired — Fri, 30 Mar 2018 18:37:24 GMT

shapefiles (yours) and geodatabase tables (mine) apparently don't support unless you 'do' something.

Maybe yours and mine is obviously not an sql thing. I never use sql, I had erroneously assumed that yours was a valid sql thing.

Which... according to the help are

Re: Calculate fields

DanPatterson_Retired — Fri, 30 Mar 2018 18:57:04 GMT

apparently....

Re: Calculate fields

KoryKramer — Fri, 30 Mar 2018 18:59:04 GMT

Or like the help says in your previous post, an enterprise geodatabase table. So... a feature service or egdb table, not file gdb or shapefile.

Re: Calculate fields

DanPatterson_Retired — Fri, 30 Mar 2018 19:01:28 GMT

I know that from the help... just waiting for Jay to see it

Re: Calculate fields

DanPatterson_Retired — Fri, 30 Mar 2018 19:10:42 GMT

Kory... this would also be a good place in the interface to put the 'verify' check box above the box rather than below and/or put all 'fail' cases in the 'messages' section when the expression fails.

Don't know if that is a big issue in updating tool verification and/or fail errors in tools. I find sometimes they aren't complete or you have to check in different places (if offered)

Re: Calculate fields

jaykapalczynski — Fri, 30 Mar 2018 19:16:10 GMT

It says that SQL Expressions were implemented to better support bla bla bla.....I read it...Better support NOT will work with these file types and not these....would be nice if the text and documentation was a bit more specific.

A simple line - Will not work with gdb or shapefiles. 7 words eliminates all this confusion.

Re: Calculate fields

DanPatterson_Retired — Fri, 30 Mar 2018 20:06:39 GMT

mystery solved... Kory will pass the comments on to Pro team I am sure.

you may as well close since Python expressions are much cooler anyway

Re: Calculate fields

KoryKramer — Fri, 30 Mar 2018 20:08:34 GMT

I already have passed this feedback about the SQL expression section of the Calculate Field help to the geoprocessing team. Thanks!