I have created a model using Modelbuilder and everything works except the very first step- the first input is a csv file and for everything else to happen, I need to convert it and save to the gdb.
When I use Export Table, the step is in color, but at the next step, Sort, there is an error with the input and the popup reads:
Input Dataset (Required)
Error 000339 Input U:\LWCF inspections\11_19\11_19.gdb\responses_ExportTable does not have OIDs. The input dataset with the records that will be reordered based on the field values in the sort field or fields.
This is confusing because through the Export Table tool, the output should have OIDs, and the Sort tool should recognize that it will. If I just run the Export Table tool manually, and the table is saved to the gdb, the rest of the model will work fine, but if I want to begin with the csv itself, the whole model turns gray at the second step (Sort). I would really like to include this step in the model, if possible, just not sure what I'm missing.
according to the error
000339: Input <value> does not have OIDs.—ArcGIS Pro | Documentation
you could try to use this tool
Copy Rows (Data Management)—ArcGIS Pro | Documentation
I appreciate your advice! I just tried that and the Sort tool still says that the input (now the output of copy rows) has no OIDs. I have also tried using Iterate Table, Copy Features, and register with geodatabase, but the model still doesn't work starting with the csv.
is the output from the Copy Rows going to a locally stored geodatabase or somewhere else? I can't tell from the model
Tables—ArcGIS Pro | Documentation
this even suggests using Export Table to control the output location. So perhaps the objectid isn't getting created because of the output location of either tool