topic I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it automatic in Geodatabase Questions

I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it automatic

JohnPavek — Mon, 24 Feb 2020 21:17:31 GMT

Put it here in case it got clipped...I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it automatically changes the calced, combined field with the new info. I have access to ArcGIS 10.5 thru 10.7 products...the DB is currently 10.2.2 but we will upgrade that soon. Any ideas? I know this may not be the perfect publish location but I don't know where else to post it

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Wed, 26 Feb 2020 18:06:07 GMT

I'm not seeing much action on this. Do I have it in the right area? If not can somebody recommend where it should go?

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JoeBorgione — Wed, 26 Feb 2020 18:15:46 GMT

First off: how or when is this calculation being performed? You seem to imply your third field needs to be dynamic as the other fields apparently are. This might be a case for Introduction to attribute rules—Geodatabases | Documentation but without a little more insight, that may or may not be the route to take.

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

Asrujit_SenGupta — Wed, 26 Feb 2020 18:37:52 GMT

Multiple things come to mind:

Is using a View a possibility, as that will be dynamic?
What about a Trigger, whenever any of the two fields are updated...the third field should be updated automatically.
How many records are involved and frequency of change? Is it possible to run the calculate everyday (whatever suits your need) and then use the updated data? Probably can be done from the Database end too...

Have you already tried something and observed any issues?

On a side note: The question in the thread, need not be the entire question in itself. It should a small synopsis probably to give an idea. A lot of people ignore questions\threads, which are not formatted properly.

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Wed, 26 Feb 2020 20:05:26 GMT

Well it is not a view and we are dealing with daily change on 81,354 features. Because the symbology is built using Z whatever change is done in X & Y have to be reflected in Z. I haven't used triggers in a long time maybe that is what we need. I can explore that.

Ok about your side note...but how am I going to really give info enough to make sure people have what they need to answer? I guess they can just ask questions. I just wanted to minimize the back and forth as we all are busy.

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Wed, 26 Feb 2020 20:06:21 GMT

Thanks for the replies to Joe and Asrujit!

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JoeBorgione — Wed, 26 Feb 2020 21:00:35 GMT

As Asrujit SenGupta‌ suggests: try to keep your thread titles to a minimum. Yes, we are all busy, but for me, I'd rather get a teaser of a title and open the thread than get bored reading a lengthy one and move on before finishing it...

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Wed, 26 Feb 2020 21:29:44 GMT

I just put another thread out for a coding issue. I will try from here on to be better about this 🙂

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JoeBorgione — Wed, 26 Feb 2020 21:41:49 GMT

my suggestion for that title would be:

Python: Need help converting Tifs into a Mosaic or

Need help converting Tifs into a Mosaic with Python

and then fill us in with the details in the body of the thread.

Also, personally I never open a .zip file from anyone I don't know, no offense, just business. If you want to post code, use the syntax highlighter described here: https://community.esri.com/message/903148-re-arcmap-105-python-script-error?commentID=903148#comment-903148

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Thu, 27 Feb 2020 13:47:52 GMT

Ok...it appears I need to take a class on things with GeoNet :-). I tried to use it when it first came out but it was very useless to me because not many people replied to what you put out. Now that seems to have changed.

So Joe...do you recommend I go back and use the highlighter to put the code into the thread, start a new thread using the highlighter or just leave alone for now? As programming/coding is my weakest point I need as much help as I can get

Thanks for everything Joe.

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JoeBorgione — Thu, 27 Feb 2020 15:33:19 GMT

You can edit the original post that has the zip file attached, pasting the code into a syntax highlighter box within the body of the message. Ironically, I have been involved with a discussion for the new Geonet and in one of my posts, suggested a FAQ how-to sort of page.....

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Thu, 27 Feb 2020 15:45:50 GMT

After thinking about it...I haven't used triggers in a while. But I have a couple questions:

- I assume you are referring to a database trigger or are you thinking something within ArcCatalog or ArcMap?

- Could you provide an example of a trigger?

Thanks for everything!

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Thu, 27 Feb 2020 15:57:11 GMT

Ok...I'll give it a go. Do you have a suggestion on how I can get some more responses on my raster to mosaic post?

Do you have any further comments about the original question esp with Asrujit suggestion for a trigger? Do you have an example of a trigger you might of done?

Thank for everything Joe!

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JoeBorgione — Thu, 27 Feb 2020 16:09:45 GMT

I've used triggers in the past, but it's been a while: they are on the SQL side, not the ArcGIS side you you'll need DBA creds. Pretty sure if you do a search on Triggers or SQL Triggers you'll find something; I posted what I had done but it'll be ancient. There should be a solution that avoids a SQl trigger.

I notice your other post received a response; I'm not much help as I don't work with mosiacs....

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Thu, 27 Feb 2020 16:53:25 GMT

I'm in the same situation...done them awhile ago and don't remember much. I haven't found much about avoiding triggers 🙂

Yeah but I wish I was receiving more help on that and reach a wider audience. We are at our programming limits so we really need more help. Well as the saying goes...beggars can't be choosers. 🙂

Thanks Joe for everything

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Tue, 03 Mar 2020 14:20:59 GMT

Hi all.

I got some good info from Joe and Asrujit. But unfortunately it isn't enough for me to get going. I've tried a bunch of google searches but can't find anything definitive. Does anybody know of a ESRI doc or something that shows how to do action with triggers esp to do a calc when something changes in a field to calc another field? I keep getting ESRI stuff relative to Tracking Analyst which we don't have.

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JoeBorgione — Tue, 03 Mar 2020 14:53:25 GMT

Use the geonet search function for 'sql trigger'; you'll find a ton of results. However, I'm not sure that ESRI supports triggers (don't quote me) so another alternative might be attribute rules....

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JohnPavek — Tue, 03 Mar 2020 15:46:09 GMT

I'm dealing in anywhere from 10.5 to 10.7.1. I think attribute rules are an ArcGIS Pro thing. I'm starting to think this has to be an ESRI Tech Support call in. I may be trying to do something not possible with the version I have.

Thank Joe for the info you can give

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

JoeBorgione — Tue, 03 Mar 2020 15:53:43 GMT

Sorry- I'm only thinking Pro these days; I don't even have ArcMap/ArcCatalog installed. At any rate, you might also take a look at Attribute Assistant | ArcGIS Solutions ; I used it for a project a couple of years ago; it's more or less the predecessor to attribute rules.

Re: I have a calc that takes 2 fields and concatenates them together in a new field to use for symbology. Then I was told that the fields used are dynamic. Therefore I need the ability where if a person changes a field used in the concatenation it autom

MichaelVolz — Tue, 03 Mar 2020 16:04:25 GMT

Do you have the ability to work in Pro?

If so, can you have the data updated at night via python/modelbuilder for the next business day and use Arcade for the concatenated field symbology (Not sure Arcade can be tied to symbology but Arcade is pretty powerful so it could be an area to research)?