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?

  • 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 Jul 15 '14 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 Jul 16 '14 at 14:00

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.

  • @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 Jul 15 '14 at 21:19
  • My mistake was looking at a different tool. – artwork21 Jul 16 '14 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 Jul 16 '14 at 12:16
  • @Hornbydd I also want to update rows but found the required tools (delete) in the toolset you linked, thanks! – Sebastian Jul 16 '14 at 13:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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