I am working with a table that I am making trying to query and take the features that are selected from the query to a new layer/feature class but I am not sure why it is not working. I don't get any error's, using Python 3.6.8.
I have tried Copy features and Table to geodatabase conversion but nothing gets created.
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"D:\Temp\temp.gdb"</SPAN>
origin_table <SPAN class="operator token">=</SPAN> <SPAN class="string token">"LV"</SPAN>
Clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"group_code IN ('01','02','03','05')"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeQueryTable_management<SPAN class="punctuation token">(</SPAN>origin_table<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"tmp_view"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_KEY_FIELD"</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>Clause<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>TableToGeodatabase_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"tmp_view"</SPAN><SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">"D:\Temp\temp.gdb"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#arcpy.CopyFeatures_management("tmp_view", r"D:\Temp\temp.gdb\LV_1")</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN><SPAN></SPAN></SPAN>