nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Splitting data in an attribute table into multiple fields

SimonCrutchley

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 Splitting data in an attribute table

Split_demo.zip

Encontre mais publicações marcadas com

Accepted answers

JayantaPoddar

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.

All comments

SimonCrutchley

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

JayantaPoddar

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
{
" "
}

SimonCrutchley

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

SimonCrutchley

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

JayantaPoddar

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

SimonCrutchley

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

JayantaPoddar

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.

SimonCrutchley

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

JayantaPoddar

Cool. 👍

SimonCrutchley

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. 🙂

SimonCrutchley

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.

JayantaPoddar

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).

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.