Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm using the following script to load identical QVD files:
Target_Date as Date
From $(vPathTempData)Target_NO*.qvd (qvd);
STORE Targets_Metrics into $(vPathQVD)Targets_Metrics.qvd (qvd);
DROP Table Targets_Metrics;
But after dropping the table, there is a table with that name left in the model:
Why does it happen?
The QVD files do not have identical fields, so the QVD was not concatenated and a -1 table was created. The DROP table references the original table only. This script will enforce the concatenation:
LOAD 0 as Date AUTOGENERATE 0; // create empty table as concatenation target
Concatenate(Targets_Metrics) //force concatenation
View solution in original post
You are right... the tables were not identical..
The original script did concatenate and stored only the identical ones, and the table Target_Metrics-1 has the different one...