How can I pass along null (None) values through NumPyArrayToTable?

9507
10
Jump to solution
03-30-2018 08:51 AM
BlakeTerhune
MVP Regular Contributor

I am querying data from another Oracle database, doing some work on the data, geocoding it, then appending it to a feature class in our enterprise geodatabase. I use ArcSDESQLExecute(), then NumPyArrayToTable() to pass into GeocodeAddresses_geocoding(). However, during the NumPyArrayToTable() process, null values always come through as a text string 'None'. I tried changing None values to numpy.NaN but those just come through as a string 'nan'. My datatypes for my numpy array fields are all string. How do you deal with null values with NumPyArrayToTable()?

0 Kudos
10 Replies
DanPatterson_Retired
MVP Emeritus

probably a wise move, because of the multitude of 'standard' formats

0 Kudos