Hello, I am working with a for loop where a summary statistics is created. I am able to store the output to a custom file gdb using TableToTable conversion. However, I'm not able to append data to it on the following iterations. How can I go about this? if hubDict [ 0 ] : arcpy . TableToTable_conversion ( in_rows , out_path , out_name ) else : arcpy . Append_management ( inputs , target , "NO_TEST" ) hubDict is a dictionary i have created earlier on. in_rows, out_path, out_name, inputs, target are all variables that are defined to the correct files and output locations.

After looking at your code, I changed my approach to take the path of least modifying your code: for i , hub in enumerate ( hubDict ) : valueHub = dict . get ( hubDict , hub ) hubQuery = "HubName = " + "'" + str ( valueHub ) + "'" nodeQuery = "ProjectHub = " + "'" + str ( valueHub ) + "'" hubLayer . definitionQuery = hubQuery nodeLayer . definitionQuery = nodeQuery if i == 0 : in_rows = 'table' out_path = folderPath + '/' + 'Results.gdb' out_name = 'Results' arcpy . TableToTable_conversion ( in_rows , out_path , out_name ) else : inputs = 'table' target = folderPath + '/' + 'Results.gdb' + '/' + 'Results' arcpy . Append_management ( inputs , target , "NO_TEST" )

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

How to store first iteration of loop in a defined location and the rest of the iterations to append to first iteration results?

VishalShah2

Hello,

I am working with a for loop where a summary statistics is created. I am able to store the output to a custom file gdb using TableToTable conversion. However, I'm not able to append data to it on the following iterations. How can I go about this?

<SPAN class="keyword token">if</SPAN> hubDict<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>in_rows<SPAN class="punctuation token">,</SPAN> out_path<SPAN class="punctuation token">,</SPAN> out_name<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN>inputs<SPAN class="punctuation token">,</SPAN> target<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_TEST"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

hubDict is a dictionary i have created earlier on. in_rows, out_path, out_name, inputs, target are all variables that are defined to the correct files and output locations.

Find more posts tagged with

Accepted answers

JoshuaBixby

After looking at your code, I changed my approach to take the path of least modifying your code:

<SPAN class="keyword token">for</SPAN> i<SPAN class="punctuation token">,</SPAN> hub <SPAN class="keyword token">in</SPAN> enumerate<SPAN class="punctuation token">(</SPAN>hubDict<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; valueHub <SPAN class="operator token">=</SPAN> dict<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN>hubDict<SPAN class="punctuation token">,</SPAN> hub<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; hubQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"HubName = "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>valueHub<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN>
&nbsp;&nbsp;&nbsp; nodeQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ProjectHub = "</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>valueHub<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"'"</SPAN>
&nbsp;&nbsp;&nbsp; hubLayer<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> hubQuery
&nbsp;&nbsp;&nbsp; nodeLayer<SPAN class="punctuation token">.</SPAN>definitionQuery <SPAN class="operator token">=</SPAN> nodeQuery
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> i <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in_rows <SPAN class="operator token">=</SPAN> <SPAN class="string token">'table'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out_path <SPAN class="operator token">=</SPAN> folderPath <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'Results.gdb'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; out_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Results'</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>in_rows<SPAN class="punctuation token">,</SPAN> out_path<SPAN class="punctuation token">,</SPAN> out_name<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; inputs <SPAN class="operator token">=</SPAN> <SPAN class="string token">'table'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; target <SPAN class="operator token">=</SPAN> folderPath <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'Results.gdb'</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'Results'</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN>inputs<SPAN class="punctuation token">,</SPAN> target<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_TEST"</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>

All comments

JoshuaBixby

Are you getting an error or unexpected results? If the former, what error, exactly (include the traceback). If the latter, what do you expect and what are you getting?

VishalShah2

Hi Joshua,

Sorry about the delay in getting back to you. So my script first creates a dictionary per feature in a feature class. Then the script runs a for loop per feature in the feature class using the values in the dictionary. Rather than exporting several tables and their excel sheets, I am trying to create a table with the first iteration using table to table (conversion) and then for the rest of the iterations, I want their tables to append to the created table from the first iteration. The way I have it set up is the following:

<SPAN class="keyword token">if</SPAN> hubDict<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; in_rows <SPAN class="operator token">=</SPAN> <SPAN class="string token">'table'</SPAN>
&nbsp;&nbsp;&nbsp; out_path <SPAN class="operator token">=</SPAN> folderPath <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'Results.gdb'</SPAN>
&nbsp;&nbsp;&nbsp; out_name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Results'</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>in_rows<SPAN class="punctuation token">,</SPAN> out_path<SPAN class="punctuation token">,</SPAN> out_name<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; inputs <SPAN class="operator token">=</SPAN> <SPAN class="string token">'table'</SPAN>
&nbsp;&nbsp;&nbsp; target <SPAN class="operator token">=</SPAN> folderPath <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'Results.gdb'</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'/'</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'Results'</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN>inputs<SPAN class="punctuation token">,</SPAN> target<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_TEST"</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>

The Results table is being created on the first iteration but on the second one, the data isn't getting appended.

JoshuaBixby

Are you sure Append is being executing? If so, capture the Result—Help | ArcGIS Desktop and see what messages it is giving.

VishalShah2

It's not being executed because of the else statement. I don't think I set that up correctly nor do I know how to fix that. For some reason that is not registering on the second iteration and would love it if you have any ideas on how to approach this scenario..

VishalShah2

When I run the steps outside of the main for loop, the append is being executed correctly. My issue is not sure how to script it for the script to read it as the first iteration or Xth iteration. I want the first iteration to create the table and the following iterations to be appended to it.

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.