Sometimes when I partial reload and add tables (let's call it NULLFACTS) without fully taking into account what I'm attempting to do, Qlikview will automatically create a second table labeled NULLFACTS-1 if I do a Replace and partial load without dropping the table first.
Even if I drop my NULLFACTS table after it has happened, NULLFACTS-1 still exists and I have no idea how to remove it. Trying to add a statement like Drop Table NULLFACTS-1; comes up with an error stating that no such table exists. When this occurs I usually close without saving and reopen the file, but there must be a way to remedy it without having to do this. Does anyone know how to remove it?