Lookup table unused values in project plan RRS feed

  • Question

  • Hi,

    We have a lookup table with 10,000+ rows and it is taking lot of time to open and perform operations on it.

    So, we need to find out if there are any Lookup table values that are unused or else are being used in completed projects. These values can then be deleted.

    We needed help to figure out if there is a way that we can query the database to find out such values. Please if anyone can suggest some solution, it will be very helpful.

    Thanks in advance.


    Friday, June 14, 2019 7:26 AM

All replies

  • Hi Komal,

    Im not sure about query but 

    I can suggest a way, write a small CSOM  application. Loop through each lookup item, loop through each project and tasks to and check if this lookup value has been used or not, if there is a match then this lookup item is under use, otherwise not in use. This way you can find the unused lookup items to delete.

    Rajkumar Allepu (MCP) , | ** Please mark it as answer if my answer would resolved your issue.

    Friday, June 14, 2019 8:44 AM
  • Assuming this lookup table is associated with Tasks, bring the task rows into Power BI, and then using power query, you could just remove all the columns in the task query other than your custom list, remove duplicates, and that this the list of the ones you are using.   The same can be done in Excel.

    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Friday, June 14, 2019 5:40 PM