Autofill data set - clearing the data OB16

[Ellen_A_Barry]

There was a refresh of our test environment and need to clear all AF data and replace.  One of the AF data sets was done incorrectly and now contains duplicate records and need to start over.   

The data in this AF has too many rows to try and select and delete via the thick client Autofill Keyword set maintenance.

Any Tips &Tricks ?  

Any Rules around deleting via SQL?  Would I be breaking rules ?

Is this the correct Forum to ask this question as well?

Thanks

Ellie Barry

Dawn Foods - Jackson MI

[James_Perry]

If you choose the replace option during the import it should clear everything out. 

[Ellen_A_Barry]

That was how I started this mess.  This particular AF data is created via an automated process and allows multiple records.  This option overlays the first record if 2 are sent.  I then tried the import with nothing checked and caused the duplication.  

I need to clear the data before starting again and import with nothing checked to pull in all data.  Is there another way?