topic Remove duplicate Qlikview generated TABLE-1 in QlikView https://community.qlik.com/t5/QlikView/Remove-duplicate-Qlikview-generated-TABLE-1/m-p/1394211#M801763 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Even if I drop my NULLFACTS table after it has happened, NULLFACTS-1 still exists and I have no idea how to remove it.&nbsp; Trying to add a statement like Drop Table NULLFACTS-1; comes up with an error stating that no such table exists.&nbsp; 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.&nbsp; Does anyone know how to remove it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT anothergreg 2020-11-25T16:16:04Z Remove duplicate Qlikview generated TABLE-1 https://community.qlik.com/t5/QlikView/Remove-duplicate-Qlikview-generated-TABLE-1/m-p/1394211#M801763 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Even if I drop my NULLFACTS table after it has happened, NULLFACTS-1 still exists and I have no idea how to remove it.&nbsp; Trying to add a statement like Drop Table NULLFACTS-1; comes up with an error stating that no such table exists.&nbsp; 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.&nbsp; Does anyone know how to remove it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Remove-duplicate-Qlikview-generated-TABLE-1/m-p/1394211#M801763 anothergreg 2020-11-25T16:16:04Z