topic Make table query copy features in Python Questions

Make table query copy features

CCWeedcontrol — Fri, 10 Dec 2021 22:41:28 GMT

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.workspace = r"D:\Temp\temp.gdb"
origin_table = "LV"

Clause = "group_code IN ('01','02','03','05')"

arcpy.MakeQueryTable_management(origin_table, "tmp_view", "NO_KEY_FIELD", "", "",Clause)
arcpy.TableToGeodatabase_conversion("tmp_view", r"D:\Temp\temp.gdb")
#arcpy.CopyFeatures_management("tmp_view", r"D:\Temp\temp.gdb\LV_1")‍‍‍‍‍‍‍‍

Re: Make table query copy features

DanPatterson — Fri, 19 Jun 2020 23:21:52 GMT

a where clause won't do?

Feature Class to Feature Class—Conversion toolbox | Documentation

Re: Make table query copy features

JoshuaBixby — Sat, 20 Jun 2020 01:13:30 GMT

Have you tried using Make Table View—Data Management toolbox | Documentation ? Make Query Table can be temperamental.