What is the correct way to clear and repopulate a persistent lookup?
I am using a shared persistent lookup as a method of locally storing a common set of mappings that need to be referenced by multiple graphs. However, when i get a new set of mappings that i need to upload it's very difficult to clear the existing values in the lookup and repopulate; i tried using the "Clear lookup table after finish" option in the LookupTableReaderWriter Component but this does nothing. The only method I can see is to physically delete the .db file which is stored - this often isn't possible as it seems they're held by some resources for a period of time so have to wait 5/10 minutes since the lookup was last used by a graph.
Am i using the lookup in the correct way? Is there a better way of approaching keeping local (not in a db) values for multiple graphs to reference?