TableSelect_analysis ( in_table , out_table , { where_clause } ) "Selects table records matching a Structured Query Language (SQL) expression and writes them to an output table." Using this function I have this simple script: import arcpy from arcpy import env env . workspace = r '\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb' #variables intable = r "\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb\ElectionResults_Nov2016" outtable = r "\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb\Results3" where_clause = "ContestTitle = 'BALLOTS CAST - TOTAL'" arcpy . TableSelect_analysis ( intable , outtable , where_clause ) It selects all records named 'BALLOTS CAST - TOTAL' from the 'ContestTitle' column of my 'ElectionResults_Nov2016' table and writes them in the newly created 'Results3' table. 'BALLOTS CAST - TOTAL' is only one of 58 separate table record names. How can I write all 58 to their own tables? Thanks for any help.

UPDATED: I did a quick test of this, so it should work. For a file geodatabase, to match a single quote in a field, you escape the single quote with a second one (not \' ); I've made a correction in the code. It should now replace the single quote in the where_clause with an escaped one and remove any non-alphanumeric characters, etc. for table name. I also added a couple of lines (20-21) to delete tables if found; you may or may not want to do this. import arcpy from arcpy import env import re env . workspace = r "Path\to\filedatabase.gdb" intable = "ElectionResults_Nov2016" tbList = [ ] for row in arcpy . da . SearchCursor ( intable , "ContestTitle" ) : if row [ 0 ] not in tbList : tbList . append ( row [ 0 ] ) for tbl in tbList : where_clause = "ContestTitle = '{}'" . format ( tbl . replace ( "'" , "''" ) ) tbl_fmt = ' ' . join ( re . sub ( '[^0-9a-zA-Z ]' , '' , tbl . strip ( ) ) . split ( ) ) . replace ( " " , "_" ) if arcpy . Exists ( tbl_fmt ) : arcpy . Delete_management ( tbl_fmt ) # this will delete the table if it exists arcpy . TableSelect_analysis ( intable , tbl_fmt , where_clause )

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

(arcpy) Multiple TableSelect_analysis?

JaredPilbeam2

TableSelect_analysis<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="punctuation token">,</SPAN> out_table<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">{</SPAN>where_clause<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

"Selects table records matching a Structured Query Language (SQL) expression and writes them to an output table."

Using this function I have this simple script:

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

env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb'</SPAN>

<SPAN class="comment token">#variables</SPAN>
intable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb\ElectionResults_Nov2016"</SPAN>
outtable <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"\\gisfile\GISstaff\Jared\ModelBuilder\JaredTest.gdb\Results3"</SPAN>
where_clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ContestTitle = 'BALLOTS CAST - TOTAL'"</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> outtable<SPAN class="punctuation token">,</SPAN> where_clause<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>

It selects all records named 'BALLOTS CAST - TOTAL' from the 'ContestTitle' column of my 'ElectionResults_Nov2016' table and writes them in the newly created 'Results3' table. 'BALLOTS CAST - TOTAL' is only one of 58 separate table record names. How can I write all 58 to their own tables?

Thanks for any help.

Najděte více příspěvků označených jako

Accepted answers

RandyBurton

UPDATED: I did a quick test of this, so it should work. For a file geodatabase, to match a single quote in a field, you escape the single quote with a second one (not \' ); I've made a correction in the code. It should now replace the single quote in the where_clause with an escaped one and remove any non-alphanumeric characters, etc. for table name. I also added a couple of lines (20-21) to delete tables if found; you may or may not want to do this.

<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> re

env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Path\to\filedatabase.gdb"</SPAN>

intable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ElectionResults_Nov2016"</SPAN>

tbList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ContestTitle"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> tbList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tbList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> tbl <SPAN class="keyword token">in</SPAN> tbList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; where_clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ContestTitle = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">.</SPAN>replace<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="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; tbl_fmt <SPAN class="operator token">=</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>re<SPAN class="punctuation token">.</SPAN>sub<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'[^0-9a-zA-Z ]'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> tbl<SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>replace<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; <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>tbl_fmt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>tbl_fmt<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># this will delete the table if it exists</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> tbl_fmt<SPAN class="punctuation token">,</SPAN> where_clause<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>

All comments

JaredPilbeam2

Randy,

It works pretty flawlessly, thanks! Could you briefly explain how the dictionary works in this script?

tbList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

RandyBurton

<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> re

env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Path\to\filedatabase.gdb"</SPAN>

intable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ElectionResults_Nov2016"</SPAN>

tbList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ContestTitle"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> tbList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tbList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> tbl <SPAN class="keyword token">in</SPAN> tbList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; where_clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ContestTitle = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">.</SPAN>replace<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="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; tbl_fmt <SPAN class="operator token">=</SPAN> <SPAN class="string token">' '</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>re<SPAN class="punctuation token">.</SPAN>sub<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'[^0-9a-zA-Z ]'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> tbl<SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>replace<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; <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>tbl_fmt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>tbl_fmt<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># this will delete the table if it exists</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> tbl_fmt<SPAN class="punctuation token">,</SPAN> where_clause<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>

RandyBurton

For table names from the field data, you would need to replace anything that wasn't a letter, number or underscore. As an alternate, you might take the last word in the field data by using split on the last space.

tbls_fmt <SPAN class="operator token">=</SPAN> tbls<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

The error you mentioned occurred when a single quote was not escaped in the where clause:

where <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SELECT * FROM ElectionResults_Nov2016 WHERE ContestTitle = 'STATE'S ATTORNEY'"</SPAN>

<SPAN class="comment token"># should be</SPAN>
where <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SELECT * FROM ElectionResults_Nov2016 WHERE ContestTitle = 'STATE''S ATTORNEY'"</SPAN>

flds <SPAN class="operator token">=</SPAN> <SPAN class="string token">"STATE'S ATTORNEY"</SPAN> <SPAN class="comment token"># single quote inside double quotes, escape not needed</SPAN>

ContestTitle <SPAN class="operator token">=</SPAN> flds<SPAN class="punctuation token">.</SPAN>replace<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="comment token"># for file geodatabase, use 2 single quotes‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Hope this helps.

EDIT: When using a where statement to find a value in a file geodatabase with an apostrophe, escape the single quote by adding a second one.

JaredPilbeam2

Randy,

Thanks for the help. All options are great. I went with the last one. I copied the script verbatim and it wrote new tables successfully except for one table, Results31. It's hung up. I did a few things to troubleshoot this: closed everything, used the 'ElectionResults_Nov2016' file in a different workspace, made sure the 'STATES ATTORNEY' record was even there...

Traceback (most recent call last):
&nbsp; File "C:\Python27\ArcGIS10.4\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 326, in RunScript
&nbsp;&nbsp;&nbsp; exec codeObject in __main__.__dict__
&nbsp; File "\\gisfile\GISstaff\Jared\Python Scripts\Test2.py", line 22, in <module>
&nbsp;&nbsp;&nbsp; arcpy.TableSelect_analysis(intable, v, where_clause)
&nbsp; File "C:\Program Files (x86)\ArcGIS\Desktop10.4\ArcPy\arcpy\analysis.py", line 145, in TableSelect
&nbsp;&nbsp;&nbsp; raise e
ExecuteError: ERROR 999999: Error executing function.
An invalid SQL statement was used.
An invalid SQL statement was used. [ElectionResults_Nov2016]
An invalid SQL statement was used. [SELECT * FROM ElectionResults_Nov2016 WHERE ContestTitle = 'STATE'S ATTORNEY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ']
The table was not found. [Results31]
Failed to execute (TableSelect).‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>

**EDIT: the 'STATE'S ATTORNEY' record is the only one with an apostrophe. So, I'm guessing this may be a format issue. I'm attempting to use the substitution function to get rid of it.

<SPAN class="keyword token">import</SPAN> re
re<SPAN class="punctuation token">.</SPAN>sub<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> ‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Also, instead of naming the new tables 'Results' how would you give them the table record's name?

RandyBurton

A dictionary version would also work:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Path\to\filedatabase.gdb"</SPAN>

intable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ElectionResults_Nov2016"</SPAN>
<SPAN class="comment token"># outtable will be named Results##</SPAN>

<SPAN class="comment token"># you can manually create a dictionary</SPAN>
tblDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'BALLOTS CAST - TOTAL'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Results1'</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'BALLOTS CAST - DISTRICT'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Results2'</SPAN> <SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">for</SPAN> k<SPAN class="punctuation token">,</SPAN> v <SPAN class="keyword token">in</SPAN> tblDict<SPAN class="punctuation token">.</SPAN>iteritems<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> k<SPAN class="punctuation token">,</SPAN> v

<SPAN class="comment token"># or automatically create one by scanning the intable</SPAN>
tblDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN> <SPAN class="comment token"># empty dictionary</SPAN>
results <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token"># counter for output tables</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ContestTitle"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> tblDict<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblDict<SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Results{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>results<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; results <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="comment token"># increment results counter</SPAN>

<SPAN class="comment token"># create the new tables</SPAN>
<SPAN class="keyword token">for</SPAN> k<SPAN class="punctuation token">,</SPAN> v <SPAN class="keyword token">in</SPAN> tblDict<SPAN class="punctuation token">.</SPAN>iteritems<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; where_clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ContestTitle = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>k<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Processing table '{}' where: {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>v<SPAN class="punctuation token">,</SPAN> where_clause<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> v<SPAN class="punctuation token">,</SPAN> where_clause<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>

RandyBurton

Perhaps something like:

tbList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ContestTitle"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> tbList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tbList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> tbls <SPAN class="keyword token">in</SPAN> tbList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; where_clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ContestTitle = '{}'"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>tbls<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Note - you will need to adjust "tbls" to be a legal table name</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; no spaces, symbols, length, etc</SPAN>
&nbsp;&nbsp;&nbsp; tbls_fmt <SPAN class="operator token">=</SPAN> <SPAN class="comment token">#something to format table name here#</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN>intable<SPAN class="punctuation token">,</SPAN> tbls_fmt<SPAN class="punctuation token">,</SPAN> where_clause<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>

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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