Creating a new field from a field that contains multiple values represented as text

enryb

I'm trying to take a field called Code List which contains the abbreviations for mineral deposits (ex: AU CU PB) either convert this to a field which contains multiple values (one for each mineral) or create new fields for each mineral but am not sure how to go about this.  Any advice would be greatly appreciated.

JohannesLindner

Imagine this is your current data structure:

ID| StringField | CodeList
 1 | abc              | AU CU PB
 2 | def               | AU

 

 

To get this structure:

ID| StringField | CodeList
 1 | abc              | AU
 2 | abc              | CU
 3 | abc              | PB
 4 | def               | AU

Use the script I provided in this question.

 

To get this structure:

ID| StringField | AU | CU | PB
 1 | abc              |    1 |     1 |   1
 2 | def               |    1 |     0 |   0  

• for each mineral:
  • create the field
  • calculate the field, switch to Arcade, use this expression:

var codelist = $feature.CodeList
if(IsEmpty(codelist)) { return 0 }
if(Includes(Split(codelist, " "), "AU")) { return 1 } // change mineral here!
return 0