Python select_analysis where clause for numeric field

2461
10
Jump to solution
10-18-2016 03:52 PM
PitersonPaulgek
New Contributor III

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
New Contributor III

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