Hi everyone,

Question

As part of a larger python program, I am trying to join a table and a feature class, both residing in a gdb.  My code for the join is as follows:

inFeatures = wksp + "\[name of file, which is pretty long]"

featField = "GenericID"

joinTable = wksp + "\joinGIDcounts"

tableField = "GID"

print ("joining tables...")

arcpy.JoinField_management (inFeatures, featField, joinTable, tableField)

print ("end script")

I have these issues:

1. the program never gets to the last print statement, it just keeps running

2. when I close the program, it says "your program is still running, do you want to kill it?", and I say yes.

3. I check the inFeatures table in ArcMap and the fields from joinTable are there and joined correctly

4. I try to delete the fields, because this is only a test of the first 200 records of a table with a few thousand records

5. I get a message saying cannot delete fields because of an existing lock.  But I killed the Python program when I closed it.

Does anyone know why I am stuck here?

Many thanks

MaryBandziukas · Answer

OK, thanks.  I am completely new to numpy and pandas.  I'm trying to move away from excel.  This is my first question posted to GeoNet, so thanks for showing me what a great resource it is.  Looking forward to learning what numpy can do (and maybe Pandas)

danretired · Answer

a table coming from an array can be joined to a featureclass since it has a table.

I skip excel (and Pandas for that matter) and just use numpy and its ndarray and chararray handle number and text processing

MaryBandziukas · Answer

so many choices

ExtendTable joins an array to a table, I need to join a table (or array) to a feature class.  Would it still work?

Also, the feature class does not have unique values in its join field; if I provide only unique values in the join table, I will have a N:1 join, which should work fine.  e.g. if I have 3 records with the same GenericID (the join field) in the feature class, they will each be matched to the same record in the join table, which has two fields - GID (genericID - the join field) and countGID, which in this case would have the value of 3, and which tells me that this particular segment joined to 3 "valid intersection nodes" as a result of a spatial join.

I noticed that the inputs into arcpy.JoinField_management are supposed to be table views, and I didn't convert my files, just input them as feature class and table.  Perhaps that also needs attention.  I did it because I wanted to see if it would work (and then forgot that part).  Maybe not

Thanks for your continuing attention!  The whole purpose of the script is to avoid having to export to and process in excel and then re-import the spreadsheet back into the gdb.  I hope I can get it; it will make file management a bit easier