When QlikView sees two tables with the exact same field names it will Automatically concatenate the tables for you. This is to avoid synthetic keys. You can tell QlikView to stop this behavior by putting the NoConcatenate function before the second table to keep it from happening. So that, in your case, you may drop the second table in a later part of the script and not drop your entire fact table.
In QlikView, If all the columns are identical in one or more tables then it will get appended and become one single table. To avoid it we use the NoConcatenate.
The NoConcatenate prefix forces two loaded tables with identical field sets to be treated as two separate internal tables, when they otherwise would be automatically be concatenated and become one table.
It was happened the Temp_Fact and Fact become one table without the NoConcatenate.
