topic Re: Splitting data in an attribute table into multiple fields in ArcGIS Online Questions

Splitting data in an attribute table into multiple fields

SimonCrutchley — Tue, 08 Jun 2021 08:37:50 GMT

I have data in a concatenated list, created so that it is searchable in a single attribute, but I now discover that I need to make hyperlinks to the various entries

The easiest way to do this seems to be to split them into separate entries and then do a link to each unique entry, as there are far too many different combinations.

I currently have the concatenated fields separated by / e.g. the field currently called 'TYPE' has entries such as 'ENCLOSURE/FIELD/FIELD SYSTEM/SETTLEMENT' and I would like this to become a number of separate new fields TYPE1 = 'ENCLOSURE', TYPE2 = 'FIELD', TYPE3 = 'FIELD SYSTEM' etc

I attach a sample of a file where I did the split manually, to see if the process would produce the data in a form that I could then use in Portal, in a pop-up.

Hope you can help

Thanks

I suspect this may be similar to the solution given to another post I had

Re: Splitting data in an attribute table into multiple fields

JayantaPoddar — Tue, 08 Jun 2021 11:24:01 GMT

If you are sharing the data as a hosted feature layer in your ArcGIS Enterprise Portal/ ArcGIS Online, you can calculate field with the following Arcade expressions.

Type1:

Split($feature.NARROWTYPE,'\\')[0]

Type2:

Split($feature.NARROWTYPE,'\\')[1]

Type3:

Split($feature.NARROWTYPE,'\\')[2]

Edit: In the above sample, a few records missed "\" between ENCLOSED and FIELD SYSTEM, resulting in the Type1 field having value of "ENCLOSED FIELD SYSTEM". So desired substrings are separated by appropriate character (backslash in this case).

Re: Splitting data in an attribute table into multiple fields

SimonCrutchley — Tue, 08 Jun 2021 11:05:26 GMT

Thanks for that,

I will eventually be sharing it online, so might be able to do this, if I knew where to find it. However, I've tended to make the changes in ArcMap or Pro and then import them.

Re: Splitting data in an attribute table into multiple fields

SimonCrutchley — Tue, 08 Jun 2021 11:16:22 GMT

Incidentally, in this case 'ENCLOSED FIELD SYSTEM' is a correct type; there are open FIELD SYSTEMs and 'ENCLOSED FIELD SYSTEMs, so the process has worked. 🙂

Re: Splitting data in an attribute table into multiple fields

JayantaPoddar — Tue, 08 Jun 2021 11:21:12 GMT

Cool. 👍

Re: Splitting data in an attribute table into multiple fields

SimonCrutchley — Tue, 08 Jun 2021 11:26:35 GMT

However, unfortunately this still doesn't help, as I don't know where to find the 'arcade calculator' or how to use it. Please could you give me a bit more detail?

Thanks

Re: Splitting data in an attribute table into multiple fields

JayantaPoddar — Tue, 08 Jun 2021 11:30:37 GMT

Since the question was posted in ArcGIS Online space, I provided solution in ArcGIS Online.

In ArcGIS Online (Map Viewer)

In ArcGIS Pro, use Calculate Field.

Re: Splitting data in an attribute table into multiple fields

SimonCrutchley — Tue, 08 Jun 2021 11:39:08 GMT

Right, so I run it with [0] for the first entry. [1] for the second etc?

Re: Splitting data in an attribute table into multiple fields

JayantaPoddar — Tue, 08 Jun 2021 11:47:44 GMT

That's right. Choose "Arcade" as the expression type in Calculate Field in ArcGIS Pro.

Re: Splitting data in an attribute table into multiple fields

SimonCrutchley — Tue, 08 Jun 2021 12:42:59 GMT

Oops 🤔. It works for the first one, but the second gives me an error. I think I've copied what you wrote, but may have something wrong? Sorry

Re: Splitting data in an attribute table into multiple fields

SimonCrutchley — Tue, 08 Jun 2021 12:44:29 GMT

I've just realised that some entries don't have multiples, so there is no '\'. Is this the problem? If so, do I need to filter on multiples, or is there a way to do this in the script?

Thanks

Re: Splitting data in an attribute table into multiple fields

JayantaPoddar — Tue, 08 Jun 2021 13:25:37 GMT

You can use this modified script for others (except Type1). The split function uses the same logic as before, i.e. [1] for Type2 and [2] for Type3.

If (Find('\\',$feature.NARROWTYPE, 0) > 0) { Split($feature.NARROWTYPE,'\\')[1] } else { " " }

Re: Splitting data in an attribute table into multiple fields

SimonCrutchley — Tue, 08 Jun 2021 13:53:13 GMT

Thanks for that, but I'm now very puzzled, as checking 'Verify' it seems to be valid

but on actually running it, I get an error?

How is that even possible?

Sorry