Select to view content in your preferred language

Python select_analysis where clause for numeric field

3022
10
Jump to solution
10-18-2016 03:52 PM
PitersonPaulgek
Deactivated User

Hi,

I get error "Invalid expression" for:

where_clause ='"Yr" IS NULL'
arcpy.Select_analysis(InFC, OutFC, where_clause)

What is the correct syntax?

Tags (1)
0 Kudos
10 Replies
PitersonPaulgek
Deactivated User

Fortunatelly, I run the simple test (Delete and Select) - it worked in ModelBuilder and then exported to PythonScript with syntax : 

arcpy.Select_analysis(in_features,out_features, "Yr IS NOT NULL")

Thanks for help!!!

0 Kudos