Hi Ananya,Tip 1:specify a workspace without trailing slashes:replace:inputPath = "F:\\GIS\\_Projects\\NPMRDS\\GDB\\NHS_npmrds_2013.gdb\\"
by:inputPath = "F:\\GIS\\_Projects\\NPMRDS\\GDB\\NHS_npmrds_2013.gdb"
Tip 2: It is better to use os.path.join to join a location and a name:Add this to the beginning of the script:import os and change your code to:inputTable = os.path.join(inputPath, speedTable)
(this should give the same result as you already had)Do the same for inputFC, tmpQueryTable, QueryTableFeatureClass:inputFC = os.path.join(inputPath, featureClass)
tmpQueryTable = os.path.join(inputPath, "QueryTable")
QueryTableFeatureClass = os.path.join(inputPath, "copyFeatures")
Tip 3: your fieldList contains objects and not the fully qualified field names.In order to get this right, the easiest way would be to execute the tool manually. See instructions here:http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000006r000000After a successful run, open the "Results" window and right click on the successfully executed tool. This will reveal the option "Copy as Python Snippet". Now you are able to paste the python code to your Python IDE and examine what the content of each parameter has been. Adapt you script to create the same type of parameters.Tip 4: expression is not validThe expression uses names of variables, but should use the content of the variables. Use this instead and verify if you need to use fully qualified names in the expression.expression = "{0} = {1}".format(tmc1, tmc4)
this would yield: "NHS_tmc = tmc"Kind regards,Xander