Deleting multiple rows from lookup tables

Anyone know a quicker way to delete rows from a lookup table?

The only option I can see is to click on the overflow menu, then Delete Lookup Value Row.

Surely there has to be a quicker way? We need to delete 100+ rows.

1 Like

I would do DMT.

What I usually do in these situations is export my columns and data into excel, then delete the column set. This drops all your columns and data. After that I make whatever changes I need in excel and re-import everything back in.

This worked for me.

I was previously “paste inserting” changes into the data section and getting duplicate rows.

Adding the steps of: exporting the columns, deleting them and putting the columns back in worked a treat. Thanks!

Not tried the DMT option but will have a look in our test environment when I get the chance.