I am using a multivalue field parameter which is supposed to be used in a "keepList" of fields. Script makes a copy of a user defined feature class and deletes all fields from the copy except for required fields and fields from the "keepList". I am not receiving any run errors however, the fields I specify in the parameter don't show in the output feature class. What I have so far: # Appends fields detailed in the user input to keepList Keep_Fields2 = Keep_Fields . split ( ";" ) for item in Keep_Fields2 : keepList . append ( item ) # Deletes unnecesary fields from the Copy_KP fieldNames = [ f . name for f in arcpy . Describe ( Copy_KP ) . Fields if not ( f . type in [ "OID" , "Geometry" ] or f . name in [ "Shape_Length" , "Shape_Area" ] or f . name . upper ( ) in keepList ) ] if fieldNames : arcpy . DeleteField_management ( Copy_KP , fieldNames ) Notes: "Copy_KP" is the copied feature class variable. "Keep_Fields" is the the multivalue field parameter variable. The "keepList" is an empty list '[ ]' (I know this empty list may be redundant, however I have been experimenting with various methods of accomplishing this task). I am going to make the variables more intuitive after I get this thing working.

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

Multivalue Field Parameter Usage

ConnorMcivor

I am using a multivalue field parameter which is supposed to be used in a "keepList" of fields. Script makes a copy of a user defined feature class and deletes all fields from the copy except for required fields and fields from the "keepList". I am not receiving any run errors however, the fields I specify in the parameter don't show in the output feature class. What I have so far:

<SPAN class="comment token"># Appends fields detailed in the user input to keepList</SPAN>
Keep_Fields2 <SPAN class="operator token">=</SPAN> Keep_Fields<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">";"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> item <SPAN class="keyword token">in</SPAN> Keep_Fields2<SPAN class="punctuation token">:</SPAN>
	keepList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Deletes unnecesary fields from the Copy_KP	  </SPAN>
fieldNames <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>f<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>Copy_KP<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>Fields <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">.</SPAN>type <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Geometry"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">or</SPAN> f<SPAN class="punctuation token">.</SPAN>name <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Shape_Length"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Shape_Area"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">or</SPAN> f<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">in</SPAN>  keepList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>  
<SPAN class="keyword token">if</SPAN> fieldNames<SPAN class="punctuation token">:</SPAN>  
    arcpy<SPAN class="punctuation token">.</SPAN>DeleteField_management<SPAN class="punctuation token">(</SPAN>Copy_KP<SPAN class="punctuation token">,</SPAN> fieldNames<SPAN class="punctuation token">)</SPAN> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Notes: "Copy_KP" is the copied feature class variable. "Keep_Fields" is the the multivalue field parameter variable. The "keepList" is an empty list '[ ]' (I know this empty list may be redundant, however I have been experimenting with various methods of accomplishing this task). I am going to make the variables more intuitive after I get this thing working.

Find more posts tagged with

Accepted answers

RandyBurton

In line 7, you are using 'f.name.upper()' to force field names to upper case for a comparison. I don't see where you are forcing field names to upper case when you append them to 'keepList'. So, perhaps change line 4 to:

    keepList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

RandyBurton

To remove case sensitivity when comparing text the .upper() method is often used; it converts all letters in a string to upper case. If both strings are using the same case, it is easier to check for a case insensitive match. To illustrate, note the capital F in field1's value:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> field1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"myField"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> field2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"myfield"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">if</SPAN> field1 <SPAN class="operator token">==</SPAN> field2<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 	<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"match"</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 	
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">if</SPAN> field1<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> field2<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 	<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"MATCH"</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN> 	
MATCH
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> field1<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'MYFIELD'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> field2<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">'MYFIELD'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

ConnorMcivor

This was correct. I am just beginning to better familiarize myself with various string manipulation methods, and your comment makes sense although I don't fully understand it. I will research more into working with string methods. Thank you Randy!

RandyBurton

    keepList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>item<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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.