import arcpy FIPS = "C:\\Users\\D2148\\Documents\\Maps\\FIPS" FIPSlist = ('001', '003', '005', '007', '009', '011', '013', '015', '017', '019', '021', '023', '025', '027', '029', '031', '033', '035', '037', '039', '041', '043', '045', '047', '049', '051', '053', '055', '057', '059', '061', '063', '065', '067', '069', '071', '073', '075', '077', '079', '081', '083', '085', '087', '089', '091', '093', '095', '097', '099', '101', '103', '105', '107', '109', '111', '113', '115', '117', '119', '121', '123', '125', '127') for fip in FIPSlist: query = "FIPS_PARIS ='" + fip + "'" arcpy.TableSelect_analysis("Master_TAHI", FIPS + "\\FIPS" + fip + ".dbf",query)
Solved! Go to Solution.
import arcpy import sys import string import os from arcpy import env Input = arcpy.GetParameterAsText(0) Attribute = arcpy.GetParameterAsText(1) sqlclause = arcpy.GetParameterAsText(2) env.workspace = arcpy.GetParameterAsText(3) for att in Attribute: sqlclause = sqlclause + "'" + att + "'" arcpy.TableSelect_analysis(Input, Input + att + ".dbf", sqlclause)
import arcpy FIPS = arcpy.GetParameterAsText(0) FIPSlist = arcpy.GetParameterAsTest(1) SQL = arcpy.GetParameterAsTest(2) Output = arcpy.GetParameterAsTest(3) #Rest of code....
import arcpy import sys import string import os fcIn = arcpy.GetParameterAsText(0) fclist = arcpy.GetParameterAsText(1) sqlclause = arcpy.GetParameterAsText(2) fcOut = arcpy.GetParameterAsText(3) for att in fclist: arcpy.TableSelect_analysis("fcin", fcin + att + ".dbf",sqlclause)
import arcpy import sys import string import os Input = arcpy.GetParameterAsText(0) Attribute = arcpy.GetParameterAsText(1) sqlclause = arcpy.GetParameterAsText(2) env.workspace = arcpy.GetParameterAsText(3) for att in Attribute: arcpy.TableSelect_analysis(Input, Input + att, sqlclause)
import arcpy import sys import string import os from arcpy import env Input = arcpy.GetParameterAsText(0) Attribute = arcpy.GetParameterAsText(1) sqlclause = arcpy.GetParameterAsText(2) env.workspace = arcpy.GetParameterAsText(3) for att in Attribute: arcpy.TableSelect_analysis(Input, Input + att + ".dbf", sqlclause)
import arcpy import sys import string import os from arcpy import env Input = arcpy.GetParameterAsText(0) Attribute = arcpy.GetParameterAsText(1) sqlclause = arcpy.GetParameterAsText(2) env.workspace = arcpy.GetParameterAsText(3) for att in Attribute: arcpy.TableSelect_analysis(Input, Input + att + ".dbf", sqlclause)