1

I have an input csv file that I process using a python script and generate a new output csv file. I then, in the same python script use Table to Table (Conversion) in order to store the data from the output csv file in a file geo database.

The information in the input csv file will change but I'm currently only able to create a new and not update the table. So the question is, how can I update the table or if there's a smarter solution to this problem than generating and converting csv files?

Improve this question
2
  • You could use cursors to read the data from the csv and write it to your GDB table. But without knowing what kind of changes you have, it's hard to say.
    – Paul
    Commented Jul 15, 2014 at 14:31
  • @Paul Thanks, I will look in to cursors but probably I will clear the table in the geodatabase and repopulate it with data from the input csv file.
    – Sebastian
    Commented Jul 16, 2014 at 14:00

1 Answer 1

Reset to default
1

Sounds like you want to use the Append tool. So if your new data is EXACTLY the same format you could append the data to an existing table. Think of it as adding more rows to the end of the table with your new data.

Improve this answer
4
  • @artwork21 why would you need an advance license level? The help file clearly indicates it works at all license levels. What was your thinking that would require a higher license level? Just curious?
    – Hornbydd
    Commented Jul 15, 2014 at 21:19
  • My mistake was looking at a different tool.
    – artwork21
    Commented Jul 16, 2014 at 11:49
  • I was getting worried I thought you knew some killer nugget of information that stopped the Append tool working. I know the Union tool for example limits the number of layers for a basic license.
    – Hornbydd
    Commented Jul 16, 2014 at 12:16
  • @Hornbydd I also want to update rows but found the required tools (delete) in the toolset you linked, thanks!
    – Sebastian
    Commented Jul 16, 2014 at 13:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.