strZipCode = "72645" strRouteId = "C024" sqlWhereStmt="\"ZIP_CODE\"='{0}' and \"ROUTE_ID\"='{1}'".format(strZipCode, strRouteId) #MAKE A VIEW OF THE TABLE AND LIMIT THE ROWS BY THE WHERE CLAUSE arcpy.MakeTableView_management("SourceRoute_T", "SourceRoute_V", sqlWhereStmt) #COPY THE TABLE BY USING THE VIEW CREATED ABOVE arcpy.TableToTable_conversion("SourceRoute_V", "C:\\DDT\\Work\\work.gdb", "route_72645C024_T")
strZipCode = "72645" strRouteId = "C024" sqlWhereStmt="\"ZIP_CODE\"='{0}' and \"ROUTE_ID\"='{1}'".format(strZipCode, strRouteId) #MAKE A VIEW OF THE TABLE AND LIMIT THE ROWS BY THE WHERE CLAUSE arcpy.MakeTableView_management("SourceRoute_T", "SourceRoute_V") #COPY THE TABLE BY USING THE VIEW CREATED ABOVE arcpy.TableToTable_conversion("SourceRoute_V", "C:\\DDT\\Work\\work.gdb", "route_72645C024_T", sqlWhereStmt)
Solved! Go to Solution.
Can you copy in your entire code you executed?
If you have set your workspace to SDE use a staging area to save your table view.
#IMPORTS - PYTHON import os #IMPORTS - THIRD PARTY import arcpy #IMPORTS - PROJECT #ESRI - CHECKOUT LICENSE arcpy.CheckOutExtension("Network") #ESRI - Set Geoprocessing environments arcpy.env.XYResolution = "1 Meters" arcpy.env.XYTolerance = "1 Meters" #LOCAL GDB gdbWorkLoc = "D:\\arc10data\\DMS\\Scripts\\Work" gdbWorkName= "work.gdb" gdbWorkFull= "{0}\\{1}".format(gdbWorkLoc, gdbWorkName) #DATABASE PIVOT TABLE sdeDmsConn = "D:\\arc10data\\DMS\\Scripts\\DBConnections\\DAISGS-DMS.sde" dbtPivot = "{0}\\DMS_ADM.DPIVOT_T".format(sdeDmsConn) def main(): #ESTABLISH ZIP AND ROUTE TO WORK WITH strZipCode = "38111" strCridId = "C061" strZipCrid = strZipCode + strCridId #OUTPUT GDB TABLE tblRouteSingleName = "Route_{0}_T".format(strZipCrid) tblRouteSingleFull = "{0}\\{1}".format(gdbWorkFull, tblRouteSingleName) #OUTPUT VIEW OF PIVOT TABLE viewPivot = "PivotView" #CREATE OUTPUT GDB if not os.path.exists(gdbWorkFull): arcpy.CreateFileGDB_management(gdbWorkLoc, gdbWorkName) #BUILD WHERE CLAUSE TO LIMIT ROWS sqlWhere="\"ZIP_CODE\"='{0}' and \"CRID_ID\"='{1}'".format(strZipCode, strCridId) #DELETE GDB TABLE IF EXISTS if arcpy.Exists(tblRouteSingleFull): arcpy.Delete_management(tblRouteSingleFull) r1=arcpy.MakeTableView_management(dbtPivot, viewPivot, sqlWhere) r2=arcpy.TableToTable_conversion(viewPivot, gdbWorkFull, tblRouteSingleName) if __name__ == '__main__': main()
sqlWhere = "{0} = '{1}' AND {2} = '{3}'".format( arcpy.AddFieldDelimiters(dbtPivot, 'ZIP_CODE'), strZipCode, arcpy.AddFieldDelimiters(dbtPivot, 'CRID_ID'), strCridId)
arcpy.MakeTableView_management(dbtPivot, viewPivot) arcpy.TableToTable_conversion(viewPivot, gdbWorkFull, tblRouteSingleName, sqlWhere)
# arcpy.MakeTableView_management(dbtPivot, viewPivot) arcpy.TableToTable_conversion(dbtPivot, gdbWorkFull, tblRouteSingleName, sqlWhere)