AnsweredAssumed Answered

Make table query copy features

Question asked by CCweedcontrol on Jun 19, 2020
Latest reply on Jun 19, 2020 by bixb0012

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")