I get KeyError: 5 error when running my script tool.
Background of the script:
Earlier in the script, i do a summary statistics and I am editing the fields to get the field alias so the output looks cleaner because later in the script, table to excel is run to export the table. Here is what my script looks like:
fieldList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">)</SPAN>
length <SPAN class="operator token">=</SPAN> len<SPAN class="punctuation token">(</SPAN>fieldList<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>DeleteField_management<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">,</SPAN> nodeIDField<SPAN class="punctuation token">)</SPAN>
alias_dict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Network ID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Project ID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Municipality'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Node Count'</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">for</SPAN> i<SPAN class="punctuation token">,</SPAN> field <SPAN class="keyword token">in</SPAN> enumerate<SPAN class="punctuation token">(</SPAN>fieldList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="keyword token">if</SPAN> field<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">!=</SPAN> <SPAN class="string token">'OID'</SPAN><SPAN class="punctuation token">:</SPAN>
newfield <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{}new'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">,</SPAN> newfield<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>type<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>precision<SPAN class="punctuation token">,</SPAN>
field<SPAN class="punctuation token">.</SPAN>scale<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>length<SPAN class="punctuation token">,</SPAN> alias_dict<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>isNullable<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>required<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>domain<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">,</SPAN> newfield<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'!{}!'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>field<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PYTHON_9.3"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>DeleteField_management<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">,</SPAN> field<SPAN class="punctuation token">.</SPAN>name<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></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>When running this, the existing fields do get modified with the alias I want for each, but then get KeyError: 5 error. My thought is that it is because the key 5 does not exist. How do I get the script to just pass through to the next portion of the script if the key of 5 does not exist?
