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; } } }

Auto-populate field

TomPiggott

Hi,

I am doing a project were I am taking all the survey data for archaeology found in an area and trying to make it into a simple user format to show people.

(Ive pulled all the survey from a CAD drawing so excuse some of the field names). I want to take the data in the layer column and refine it. the layer column is based on the data given to the archaeology (i.e bronze age, medieval) but there are over 30 variations in the name.

so as an example. I wanted to take all the variations of the spelling of medieval(_med, _m, med, MED) in the layer column and refine them just to medieval in the 'date_refined' column. I have over 30,000 entries and didn't want to do it by hand.

I have some very basic python knowledge - could this be achieved by an else if statement? if so what would it look like?

Thanks

Tom

Find more posts tagged with

Accepted answers

Egge-Jan_Pollé

Hi Tom Piggott‌,

Workflow (manual process):

Select records WHERE "Layer" IN ('_med',' _m',' med','MED')
Use Field Calculator to update field "Date_Refined" with value 'medieval' (only selected records will be affected)
Change selection and update (using Field Calculator) with other value
Repeat until all records have a value for "Date_Refined"

Does this work for you?

Egge-Jan

All comments

TomPiggott

Thanks Egge-Jan I got it to work after changing the quotes

Thanks

Tom

Egge-Jan_Pollé

Hi Tom,

Yes, [Date_Refined] = "Medieval". Did you try that already? If it doesn't work, it should be 'Medieval'. (I always forget whether it should be single or double quotes.)

The Field Calculator only affects the selected records (unless there is no selection; in that case all records will be updated).

Please let me know how you are proceeding. If you think your issue is solved, don't forget to mark the question as being answered.

Cheers,

Egge-Jan

TomPiggott

Hi thanks for sending this through, it works by selecting the required fields.

what should i bet putting in the field calculator.

[Date_Refined] = "Medieval" ???

Egge-Jan_Pollé

Hi Tom Piggott‌,

Workflow (manual process):

Select records WHERE "Layer" IN ('_med',' _m',' med','MED')
Use Field Calculator to update field "Date_Refined" with value 'medieval' (only selected records will be affected)
Change selection and update (using Field Calculator) with other value
Repeat until all records have a value for "Date_Refined"

Does this work for you?

Egge-Jan

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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