AnsweredAssumed Answered

NumPyArrayToTable Issues?

Question asked by jamesfreddyc on Jun 4, 2013
Latest reply on Jun 6, 2013 by jamesfreddyc
Hopefully I am missing the obvious here, but there are issues with an output FGDB table (Default.gdb) that is the product of NumPyArrayToTable.

Has anyone had any issues with this?

There are no apparent issues or problems with the actual conversion, no errors and the output table appears just fine (I can load it into ArcMap and view the contents, even the field properties are all correct).  But for some reason, this output does not succesfully join to another layer (either programatically or manually).  The join operation does not fail or error, but no matches are found. 

However, if I export this FGDB table to a .dbf, it joins as expected.

code snip:
 ##convert final pandas DataFrame result into a numpyarray dfar = dfarrcombo.to_records() nmpyar = np.array(dfar, np.dtype([('staname', '|S25'), ('STATION', '|S25'), ('site', '|S25'),('change', '<f8'),('pastvalue', '<f8'), ('currentvalue', '<f8')]))   ##now covert the numpyarray to the gdb table in the default.gdb    arcpy.da.NumPyArrayToTable(nmpyar, r"H:\Documents\ArcGIS\Default.gdb\numpytab")   #....the rest of the code is a join operation 

Outcomes