*EDIT* I realized after posting this question that the code didn't quite come through as formatted as I remember the last time I posted something. Has the formatting changed, or did I do something wrong? Thanks! Hello, I have a script that I am using to iterate through a list of all fields in a feature class, run summary statistics on itself to get a table of all entries, and then creates a file geodatabase copy as well as an excel copy of the table. The tool that I have is working seemingly well, but I end up getting an error at the end. The code: # ################################################################################################### # Name: Database Check # Author: Coy Potts # Description: This tool runs a summary on all feature class fields to check for inappropriate entries. # ################################################################################################### # ################################################################################################### # Import system modules # ################################################################################################### import arcpy from arcpy import env import datetime # ################################################################################################### # Set universal variables # ################################################################################################### generalFeatures = r 'OSP Mapping Layers\General Features' dateToday = datetime . date . today ( ) outPath = r' "local_shared_drive" generalVar = "general" # ################################################################################################### # Create the workspace for the statistics documents # ################################################################################################### # ######################## # Create a dated folder # ######################## # Set local variables datedFolder = str ( dateToday ) # Create a dated folder to store the tables arcpy . CreateFolder_management ( outPath , datedFolder ) # ######################## # Create a dated geodatabase # ######################## # Set local variables outGDB = str ( dateToday ) + ".gdb" # Create a dated file geodatabase arcpy . CreateFileGDB_management ( datedFolder , outGDB , 'CURRENT' ) # ################################################################################################### # Run Statistics on the General Features feature class # ################################################################################################### # Set local variables inFC = generalFeatures fields = [ f . name for f in arcpy . ListFields ( inFC ) ] fieldCount = len ( fields ) i = 0 # ######################## # Iterate through each General Features field, exporting an associated table and excel sheet # ######################## for f in fields : while i fieldCount : # Set local variables i += 1 fieldVar = fields [ i ] statsFields = [ [ fieldVar , "COUNT" ] ] caseFields = [ fieldVar ] outTable = generalVar + "_" + fieldVar # Execute SummaryStatistics arcpy . Statistics_analysis ( inFC , outTable , statsFields , caseFields ) # Set local variables inTable = inFC saveGDB = outPath + str ( dateToday ) + "/" + outGDB # Execute TableToTable arcpy . TableToTable_conversion ( inTable , saveGDB , outTable , "" , "" , "" ) arcpy . AddMessage ( "Summary table created for the " + fieldVar + " field!" ) # Set local variables inTable = outTable outXLS = outPath + str ( dateToday ) + "/" + generalVar + "_" + fieldVar + ".xls" # Execute TableToExcel arcpy . TableToExcel_conversion ( inTable , outXLS ) arcpy . AddMessage ( "Excel sheet created for the " + fieldVar + " field!" ) print ( "General Features summary tables have been created for all fields!" ) This script runs through and does exactly what it is meant to do for each field, but then I get this error: I have 4 other feature classes that I would like to eventually add onto this script to run through the exact same process for each of the feature classes, but I can't get it to work on the second feature class with this error getting triggered after the first feature class wraps up. Any ideas why it is giving me a field type error even though the tool has technically already exported out each of the fields to tables? *SIDE NOTE* (let's fix the problem above first) The tool needs another minor tweak as well in the fact that in its current state, it creates a copy of the table in my default database before it creates a copy in my created database via the table to table function, which obviously poses the problem of having pre-existing tables when running subsequent times after the first. I had to try various workarounds when trying to get this to work initially. For instance, whenever I have an env.workspace declared under the initial while loop's local variables, I would later get an error stating that the table already existed when I tried the table to table function. However, if I removed the table to table function and relied on the env.workspace table created down in the table to excel function, I would get an error saying that the table couldn't be read.

Is this the same line 77 as in the script above. I don't think so somehow. Firstly in you script, you don't need the whole while loop. For f in fields will already iterate through the fields in the fields list. So you don't need i. And the whole of the while inner block should come in one indentation. for field in fields : statsFields = [ [ field , "COUNT" ] ] caseFields = [ field ] outTable = generalVar + "_" + field # Execute SummaryStatistics arcpy . Statistics_analysis ( inFC , outTable , statsFields , caseFields ) # Set local variables inTable = inFC saveGDB = outPath + str ( dateToday ) + "/" + outGDB # Execute TableToTable arcpy . TableToTable_conversion ( inTable , saveGDB , outTable , "" , "" , "" ) arcpy . AddMessage ( "Summary table created for the " + field + " field!" ) # Set local variables inTable = outTable outXLS = outPath + str ( dateToday ) + "/" + generalVar + "_" + field + ".xls" # Execute TableToExcel arcpy . TableToExcel_conversion ( inTable , outXLS ) arcpy . AddMessage ( "Excel sheet created for the " + field + " field!" ) print ( "General Features summary tables have been created for all fields!" ) As this appears to be run inside the python window in ArcMap, you don't need all the addmessage stuff either. I suppose you want to turn this into a script tool, but this is not doing anything at the moment. Just use some more print statements. What does the list fields look like at the moment? What is line 77 of the current script?

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

Python For Loop Error

Anonymous User

*EDIT*

I realized after posting this question that the code didn't quite come through as formatted as I remember the last time I posted something. Has the formatting changed, or did I do something wrong? Thanks!

Hello,

I have a script that I am using to iterate through a list of all fields in a feature class, run summary statistics on itself to get a table of all entries, and then creates a file geodatabase copy as well as an excel copy of the table. The tool that I have is working seemingly well, but I end up getting an error at the end.

The code:

<SPAN class="comment token"># ###################################################################################################</SPAN>
<SPAN class="comment token"># Name: Database Check</SPAN>
<SPAN class="comment token"># Author: Coy Potts</SPAN>
<SPAN class="comment token"># Description: This tool runs a summary on all feature class fields to check for inappropriate entries.</SPAN>
<SPAN class="comment token"># ###################################################################################################</SPAN>


<SPAN class="comment token"># ###################################################################################################</SPAN>
<SPAN class="comment token"># Import system modules</SPAN>
<SPAN class="comment token"># ###################################################################################################</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="keyword token">import</SPAN> datetime


<SPAN class="comment token"># ###################################################################################################</SPAN>
<SPAN class="comment token"># Set universal variables</SPAN>
<SPAN class="comment token"># ###################################################################################################</SPAN>
generalFeatures <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'OSP Mapping Layers\General Features'</SPAN>
dateToday <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>date<SPAN class="punctuation token">.</SPAN>today<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
outPath <SPAN class="operator token">=</SPAN> r'<SPAN class="string token">"local_shared_drive"</SPAN>
generalVar <SPAN class="operator token">=</SPAN> <SPAN class="string token">"general"</SPAN>


<SPAN class="comment token"># ###################################################################################################</SPAN>
<SPAN class="comment token"># Create the workspace for the statistics documents</SPAN>
<SPAN class="comment token"># ###################################################################################################</SPAN>

<SPAN class="comment token"># ########################</SPAN>
<SPAN class="comment token"># Create a dated folder</SPAN>
<SPAN class="comment token"># ########################</SPAN>

<SPAN class="comment token"># Set local variables</SPAN>
datedFolder <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Create a dated folder to store the tables</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CreateFolder_management<SPAN class="punctuation token">(</SPAN>outPath<SPAN class="punctuation token">,</SPAN> datedFolder<SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># ########################</SPAN>
<SPAN class="comment token"># Create a dated geodatabase</SPAN>
<SPAN class="comment token"># ########################</SPAN>

<SPAN class="comment token"># Set local variables</SPAN>
outGDB <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">".gdb"</SPAN>

<SPAN class="comment token"># Create a dated file geodatabase</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CreateFileGDB_management<SPAN class="punctuation token">(</SPAN>datedFolder<SPAN class="punctuation token">,</SPAN> outGDB<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'CURRENT'</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># ###################################################################################################</SPAN>
<SPAN class="comment token"># Run Statistics on the General Features feature class</SPAN>
<SPAN class="comment token"># ###################################################################################################</SPAN>

<SPAN class="comment token"># Set local variables</SPAN>
inFC <SPAN class="operator token">=</SPAN> generalFeatures
fields <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>ListFields<SPAN class="punctuation token">(</SPAN>inFC<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
fieldCount <SPAN class="operator token">=</SPAN> len<SPAN class="punctuation token">(</SPAN>fields<SPAN class="punctuation token">)</SPAN>

i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>


<SPAN class="comment token"># ########################</SPAN>
<SPAN class="comment token"># Iterate through each General Features field, exporting an associated table and excel sheet</SPAN>
<SPAN class="comment token"># ########################</SPAN>

<SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">while</SPAN> i <SPAN class="operator token"><</SPAN> fieldCount<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fieldVar <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statsFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>fieldVar<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"COUNT"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; caseFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>fieldVar<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outTable <SPAN class="operator token">=</SPAN> generalVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> fieldVar

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute SummaryStatistics</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>inFC<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> statsFields<SPAN class="punctuation token">,</SPAN> caseFields<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> inFC
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; saveGDB <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> outGDB

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute TableToTable</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> saveGDB<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Summary table created for the "</SPAN> <SPAN class="operator token">+</SPAN> fieldVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">" field!"</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> outTable
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outXLS <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> generalVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> fieldVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">".xls"</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute TableToExcel</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> outXLS<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Excel sheet created for the "</SPAN> <SPAN class="operator token">+</SPAN> fieldVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">" field!"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"General Features summary tables have been created for all fields!"</SPAN><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>‍</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><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>‍</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><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>‍</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><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

This script runs through and does exactly what it is meant to do for each field, but then I get this error:

I have 4 other feature classes that I would like to eventually add onto this script to run through the exact same process for each of the feature classes, but I can't get it to work on the second feature class with this error getting triggered after the first feature class wraps up. Any ideas why it is giving me a field type error even though the tool has technically already exported out each of the fields to tables?

*SIDE NOTE* (let's fix the problem above first)

The tool needs another minor tweak as well in the fact that in its current state, it creates a copy of the table in my default database before it creates a copy in my created database via the table to table function, which obviously poses the problem of having pre-existing tables when running subsequent times after the first. I had to try various workarounds when trying to get this to work initially. For instance, whenever I have an env.workspace declared under the initial while loop's local variables, I would later get an error stating that the table already existed when I tried the table to table function. However, if I removed the table to table function and relied on the env.workspace table created down in the table to excel function, I would get an error saying that the table couldn't be read.

Find more posts tagged with

Accepted answers

NeilAyres

Is this the same line 77 as in the script above. I don't think so somehow.

Firstly in you script, you don't need the whole while loop. For f in fields will already iterate through the fields in the fields list. So you don't need i. And the whole of the while inner block should come in one indentation.

<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp; statsFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"COUNT"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; caseFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; outTable <SPAN class="operator token">=</SPAN> generalVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> field

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute SummaryStatistics</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>inFC<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> statsFields<SPAN class="punctuation token">,</SPAN> caseFields<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> inFC
&nbsp;&nbsp;&nbsp; saveGDB <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> outGDB

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute TableToTable</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> saveGDB<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Summary table created for the "</SPAN> <SPAN class="operator token">+</SPAN> field <SPAN class="operator token">+</SPAN> <SPAN class="string token">" field!"</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> outTable
&nbsp;&nbsp;&nbsp; outXLS <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> generalVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> field <SPAN class="operator token">+</SPAN> <SPAN class="string token">".xls"</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute TableToExcel</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> outXLS<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Excel sheet created for the "</SPAN> <SPAN class="operator token">+</SPAN> field <SPAN class="operator token">+</SPAN> <SPAN class="string token">" field!"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"General Features summary tables have been created for all fields!"</SPAN><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

As this appears to be run inside the python window in ArcMap, you don't need all the addmessage stuff either. I suppose you want to turn this into a script tool, but this is not doing anything at the moment.

Just use some more print statements. What does the list fields look like at the moment?

What is line 77 of the current script?

All comments

Anonymous User

I'm simply testing in the Python window within ArcMap. I will eventually add this to a custom toolbar once it's complete. I try to see the endgame results by adding those things in as I go instead of trying to go back later and figure out what I need to put in.

I mentioned in a comment above that I have actually gotten this to work as desired, but I don't doubt that I have some inefficiencies throughout.

Overcoming the out of range error I simply created a new countVar that reduced the list of the fields by 1, since the i variable starts at 0 and not 1.

I temporarily got past the default geodatabase tables by adding a delete segment to the code.

<SPAN class="comment token"># Set local variables</SPAN>
inFC <SPAN class="operator token">=</SPAN> generalFeatures
fields <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>ListFields<SPAN class="punctuation token">(</SPAN>inFC<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> f<SPAN class="punctuation token">.</SPAN>required<SPAN class="punctuation token">]</SPAN>
fieldCount <SPAN class="operator token">=</SPAN> len<SPAN class="punctuation token">(</SPAN>fields<SPAN class="punctuation token">)</SPAN>
countVar <SPAN class="operator token">=</SPAN> fieldCount <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN>

i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>


<SPAN class="comment token"># ########################</SPAN>
<SPAN class="comment token"># Iterate through each General Features field, exporting an associated table and excel sheet</SPAN>
<SPAN class="comment token"># ########################</SPAN>

<SPAN class="keyword token">for</SPAN> f <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">while</SPAN> i <SPAN class="operator token"><</SPAN> countVar<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fieldVar <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statsFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>fieldVar<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"COUNT"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; caseFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>fieldVar<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outTable <SPAN class="operator token">=</SPAN> generalVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> fieldVar
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> outGDB

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute SummaryStatistics</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>inFC<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> statsFields<SPAN class="punctuation token">,</SPAN> caseFields<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> defaultGDB <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> outTable
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; saveGDB <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> outGDB

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute TableToTable</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> saveGDB<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Summary table created for the "</SPAN> <SPAN class="operator token">+</SPAN> fieldVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">" field!"</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> defaultGDB <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> outTable
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outXLS <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> outTable <SPAN class="operator token">+</SPAN> <SPAN class="string token">".xls"</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute TableToExcel</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> outXLS<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> defaultGDB <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> outTable

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute Delete</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Excel sheet created for the "</SPAN> <SPAN class="operator token">+</SPAN> fieldVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">" field!"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"General Features summary tables have been created for all fields!"</SPAN><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>‍</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><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

I would take some time to see if you need the field itself or the field's name or some other property.

In the following example, the actual field object is collected and is later used to print its name and type. Sometimes, you need the actual field, sometimes not.

<SPAN class="keyword token">import</SPAN> arcpy

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">demo</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; inFC <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"c:\!AV\!Data\Polylines\emst1.shp"</SPAN>
&nbsp;&nbsp;&nbsp; flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>inFC<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> i<SPAN class="punctuation token">.</SPAN>required<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> flds<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Field: {}, type {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN> i<SPAN class="punctuation token">.</SPAN>type<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> flds

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; flds <SPAN class="operator token">=</SPAN> demo<SPAN class="punctuation token">(</SPAN><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>

Result

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> 
Field<SPAN class="punctuation token">:</SPAN> ID<SPAN class="punctuation token">,</SPAN> type Integer
Field<SPAN class="punctuation token">:</SPAN> BETWEEN<SPAN class="punctuation token">,</SPAN> type String<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

NeilAyres

Is this the same line 77 as in the script above. I don't think so somehow.

<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> fields<SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp; statsFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"COUNT"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; caseFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>field<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; outTable <SPAN class="operator token">=</SPAN> generalVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> field

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute SummaryStatistics</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Statistics_analysis<SPAN class="punctuation token">(</SPAN>inFC<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> statsFields<SPAN class="punctuation token">,</SPAN> caseFields<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> inFC
&nbsp;&nbsp;&nbsp; saveGDB <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> outGDB

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute TableToTable</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> saveGDB<SPAN class="punctuation token">,</SPAN> outTable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Summary table created for the "</SPAN> <SPAN class="operator token">+</SPAN> field <SPAN class="operator token">+</SPAN> <SPAN class="string token">" field!"</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Set local variables</SPAN>
&nbsp;&nbsp;&nbsp; inTable <SPAN class="operator token">=</SPAN> outTable
&nbsp;&nbsp;&nbsp; outXLS <SPAN class="operator token">=</SPAN> outPath <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>dateToday<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> generalVar <SPAN class="operator token">+</SPAN> <SPAN class="string token">"_"</SPAN> <SPAN class="operator token">+</SPAN> field <SPAN class="operator token">+</SPAN> <SPAN class="string token">".xls"</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute TableToExcel</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>inTable<SPAN class="punctuation token">,</SPAN> outXLS<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Excel sheet created for the "</SPAN> <SPAN class="operator token">+</SPAN> field <SPAN class="operator token">+</SPAN> <SPAN class="string token">" field!"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"General Features summary tables have been created for all fields!"</SPAN><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Just use some more print statements. What does the list fields look like at the moment?

What is line 77 of the current script?

Anonymous User

Darren,

Using fieldVar.name instead returns this error:

Anonymous User

Yes, it's a feature class. That's what I referencing in my comment above. Maybe it gets through all the other fields, but then once it hits that last field then it doesn't know what to do because it's a shape field.

NeilAyres

Is the input a feature class, ie has a geometry column?

Perhaps you are trying the generate statistics on a field which makes no sense.

Anonymous User

Even though the script runs through the summary of each field and exports an associated database table and excel sheet, as intended? This process iterates through 23 separate fields before sending back this error, but the very last field in the feature class has exported just fine. I'll give your suggestion a try, just seems strange given that it works appropriately up until the end.

I'm at home and can't test right now, but I was thinking maybe it had to do with my while loop. There are 23 fields total, but that's counting all default fields as well, so the very last field is technically a shape field, thus possibly kicking back the error...? I'll have to try tomorrow when I'm back in the office.

DarrenWiens2

I think you need fieldVar.name (a string) rather than fieldVar (a field object).

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.