I really need some guidance on how to create a python script with arcpy to:
1) Search through a table for unique values in a field.
2) For the first row in each unique valueset, insert that row into a new empty table.
I have been trying to get this work with the da.SearchCursor and da.InsertCursor, but can't really get 2) to work..
The reason why I want to do this is that I have a table with two fields; "wellbore_name" is the ID for wells, "Units" are concatenated geological units for the specific well. There are several rows for each unique ID, and I want an output table with as many rows as unique IDs. Since the units are concatenated I only need one row for each ID.
This is probably easy for someone fluent in cursors, but alas I am not. Hopefully someone out there can help me with this :-)