We are trying to use a Field Calculator Processor to create a new ID field that concatenates a simple 2 character text string with a string version of the ObjectID field. The idea is that this new ID field would look something like
XX125
where 'xyz' is the string and '125' is the ObjectID value.
To achieve this in ArcGIS Pro, we used the Calculate Field tool with this Python 3 expression:
'xyz'+str(!objectid!)
The goal is to have the Field Calculator processor generate this value for new submissions to a dataset as they pass through GeoEvent, which is calculating some other fields as well.
Here are the Expressions we've tried in the Field Calculator processor. In GeoEvent the objectID field is interpreted as an integer.
'xyz'+toString(objectid)
'xyz'+objectid
concat('xyz', toString(objectid))
concat('xyz', objectid)We've also tried setting up Field Mapper processors on either side of the Field Calculator processor to change the ObjectID field from an integer to a string type, then tried both of the expressions here:
'xyz'+objectid
concat('xyz', objectid)It is unclear to me why neither of these methods (or any of the expressions listed) are working, has anyone else had similar trouble or know what might be wrong?
(We're running ArcGIS Enterprise (including GeoEvent Server) 10.7.1 on Linux)