I was wondering if anybody could help me. Im trying to create a tool within ArcMap using a python script. Within the script i've been trying figure out how to change it so that I only need to get the numerical value from GetParameterAsText. So that for the tool i do not need to include the whole SQL expression just have the user input a value.
This the last method that I have used
wf_value = arcpy.GetParameterAsText(4) wf_expression = ' "AGE_18_64"' + ">=" + "'%'" %wf_value arcpy.Select_analysis(counties, workforce, wf_expression)
ERROR MESSAGE: ExecuteError: ERROR 000358: Invalid expression 3000 Failed to execute (Select)
As I'm guessing this way doesn't work as the wf_value is a float not a string but I can't seem to get it to work whichever way I've tried. Any help or suggestions would be great! Thanks!