AnsweredAssumed Answered

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

Question asked by blake.terhune on Mar 30, 2018
Latest reply on Apr 2, 2018 by Dan_Patterson

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()?

Outcomes