Select to view content in your preferred language

Using Export Table for csv in ModelBuilder

684
3
11-26-2024 05:40 AM
ElizabethOswaldDNR
Emerging Contributor

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.

0 Kudos
3 Replies
DanPatterson
MVP Esteemed Contributor
0 Kudos
ElizabethOswaldDNR
Emerging Contributor

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.

0 Kudos
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos