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")
Solved! Go to Solution.
Have you tried using Make Table View—Data Management toolbox | Documentation ? Make Query Table can be temperamental.
a where clause won't do?
Feature Class to Feature Class—Conversion toolbox | Documentation
Have you tried using Make Table View—Data Management toolbox | Documentation ? Make Query Table can be temperamental.