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.
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.
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.