Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
anothergreg
New Contributor III

Remove duplicate Qlikview generated TABLE-1

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?